How to send Email with File Attachment from SharePoint List when Item is created?

Sdílet
Vložit
  • čas přidán 11. 07. 2024
  • During this session, we will talk about one of the most common problems which we are facing in our daily routine. SharePoint allows users to attach multiple files as a list attachment. Sometimes we need to send an email when a new item is created to the SharePoint List. With Email, we also want to attach all the files attached with the list item. So, how we can achieve this requirement? How can we send an Email with a File Attachment from SharePoint List when a new item is created in SharePoint List. The flow creation procedure is very simple and straightforward.
    You will learn the following things during this session:
    - Sending Emails with an attachment from SharePoint Lists
    - Send SharePoint List Attachments in Email using Power Automate
    - How To Send Listitem Attachments As Email Attachment From Power Automate?
    - Power Automate - Get File Attachments from SharePoint List Item
    Chapters:
    00:00 Start
    01:09 Requirement
    02:00 Overall Idea of Flow
    02:38 Create Cloud Flow
    08:06 Test Flow
    09:54 Subscribe
    **************
    Download Code:
    github.com/Dhruvinshah16/Powe...
    ***
    Follow me on Instagram:
    / powerplatformguy
    Looking for Consultancy? Connect Here!
    powerplatformtrainings.com/co...
    Follow me on all social Media Handles:
    linktr.ee/dhruvin.shah
    ****
    #PowerAutomate #MicrosoftFlow #PowerPlatform #Attachments #PowerAddicts #PowerAutomateWithDhruvin #DhruvinShah #DigitalDhruvin
    #Microsoft

Komentáře • 56

  • @nikstaron6843
    @nikstaron6843 Před 2 lety +1

    Exactly what I needed for my projects. Thank you so much for sharing and showing how this is done.

  • @arielfriedman5530
    @arielfriedman5530 Před 2 lety +2

    Dear Dhruvin,
    Great job!
    Besides this video is exactly what I've been looking for, You have created it professionally "straight to the point".

  • @richarddiasribeiro429
    @richarddiasribeiro429 Před 2 lety

    that was exactly what I was needing! thank you so, so much!!! :)

  • @leodibiagio
    @leodibiagio Před 2 lety

    excellent video! thanks!

  • @AlvaroGonzalez-Mayor
    @AlvaroGonzalez-Mayor Před rokem

    THANK YOU, PERFECT!

  • @stevehajec9209
    @stevehajec9209 Před 2 lety

    Thank you very much!

  • @dylanroxxxursoxxx
    @dylanroxxxursoxxx Před rokem

    You are the best!

  • @Ms25Alicia
    @Ms25Alicia Před rokem

    Great video!

  • @qiangzhao7975
    @qiangzhao7975 Před 2 lety

    thanks, it is what I am looking for

  • @user-sj5km8qt7w
    @user-sj5km8qt7w Před 7 měsíci

    Great Explanation Sir. Please keep posting such Videos.

  • @KiranNaidu-nj8dy
    @KiranNaidu-nj8dy Před 2 měsíci

    thank you so Much!

  • @tamyizulmuchtar705
    @tamyizulmuchtar705 Před 9 měsíci

    Dear Dhruvin,
    Thanks

  • @laszlogyor6628
    @laszlogyor6628 Před rokem

    Thank you, it is an excellent video. You helped for me a lot.

  • @souhailjalal5198
    @souhailjalal5198 Před rokem

    Many thanks for the video, you helped me a lot

  • @chairattangthong
    @chairattangthong Před 8 měsíci

    ❤ thank you so much 😊

  • @jawadullah5333
    @jawadullah5333 Před rokem

    You are amazing Sir. Great work really approciated

  • @chandradeepwaghare6359
    @chandradeepwaghare6359 Před 5 měsíci

    thanks bhai.... solve my problem !... thanks and great work.....

  • @fabienyao38
    @fabienyao38 Před 2 lety

    UR JUST TOO GOOD

  • @derekgreig6905
    @derekgreig6905 Před 2 lety

    This is excellent, thank you very much. Very easy to work along to re-create. I have this running but I want to be able to attach the actual Sharepoint list I have created within my app as shopping cart order. How can this be altered to be able to do that?

  • @naveenkumarakula7448
    @naveenkumarakula7448 Před 2 lety

    Hi Dhruvin,
    Thank you for the video, it is very helpful.
    I have a problem where attachments are missing, so i would like to add a delay till (not for some seconds) the attachment added fully. So could you show me a example / condition how to check whether the attachment(s) are added fully with all content?
    Thank you.

  • @hamdafasla876
    @hamdafasla876 Před 2 lety

    Thank You Dhruv for this video. Could you please explain how to sent an email to the admin and user if the uploaded folder in sharepoint is empty

  • @lestermagtuto380
    @lestermagtuto380 Před rokem

    Hi Dhruvin, do you have video tutorial on how to send mail for multiple files in document library using power automate?

  • @ShaneStenhjem
    @ShaneStenhjem Před rokem

    Hello Dhruvin. Thanks for the great video. I know this is old video, I do have a question that I can not find the answer. I am getting error Action 'Get_attachments' failed. The length of the URL for this request exceeds the configured maxUrlLength value. Have you seen this before? Do you know of a solution?

  • @radheneeyati3
    @radheneeyati3 Před 4 měsíci

    Hi dhruvin , facing problem in json coding under apply to each - m unable to search dynamic value under contentbytes. There is no option of get attachment....

  • @shubhamteke2856
    @shubhamteke2856 Před rokem

    Hi Dhruvin, I want to embed image from attachemnt column of list in email body of power automate. How we can achieve that one?

  • @cast7430
    @cast7430 Před 2 lety

    Thank you for this video. Is it possible to follow this process but instead of have it trigger when a new item is created or modified - trigger an email with the attachments triggered by a due date in my list?

  • @xslee25
    @xslee25 Před 3 lety +1

    Quick question.
    The process runs smooth but if attachment is not compulsory to add in, the process will jammed at PARSE JSON which is understandable (nothing found). May I know how to overcome it as if I put condition (with / without attachment), PARSE JSON will only work before condition not in condition.
    Thanks.

  • @BahayCavite
    @BahayCavite Před rokem

    Hi Dhruvin, the explanation is very helpful! I managed to make it work, the only problem is you use send email v2, I tried using v3 but I can't find the variable array. Is there any workaround on using Emailv3? Thanks!

  • @MitchTorres
    @MitchTorres Před 2 lety

    Thank you for this Sir :) i have followed this through, but why am I not able to view the attachments? is there something wrong with my flow?

  • @panditipradeep1092
    @panditipradeep1092 Před 2 lety

    Hello Bro, I just use the steps for the "start and wait approval" and it's showing some error like couldn't find member 'contenBytes' on object of type..... Can you please help me for that.......... I need it bro

  • @matthewlogan3374
    @matthewlogan3374 Před 2 lety

    Hi Dhruvin
    I have followed the steps for your flow and it works really well when sending one regular email. My flow I am trying to setup sends to different parties based on conditions. Unfortunately the flow is not working so I am not sure where I have gone wrong. Are there some suggestions you could help me with? Thank you, Matt

  • @chetansoni139
    @chetansoni139 Před 2 lety +1

    Hi, i'm getting error. if the Attachment is empty.
    can you please help me.
    wants to create a flow, if the attachment present. - then attach it with email.
    if no attachment - send the data only in email

  • @iram1414
    @iram1414 Před 2 lety

    Hello,
    Thank you for this video.
    How could I do if I need to send an attachment based on a forms response.?
    What I would need the flow to do is to:
    1-Get response from form
    2- compare response with list
    3- select attachment (s)
    4- send attachment via email to survey respondent

  • @corby8678
    @corby8678 Před 3 lety

    Dear Sir
    Please can you make video tutorail on powerapps images not display on mobile

  • @user-ti5jg6hw9s
    @user-ti5jg6hw9s Před rokem

    Great video, everything worked except for the last part for me. It keeps giving the following error: The error message "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'" indicates that the email action is missing the required input parameters.

  • @mosycitytravelvlogs533

    How to send separate email attachment to different users with different email addresses individually.... please help

  • @prakashsrinivasan7840
    @prakashsrinivasan7840 Před 2 měsíci

    The Attachments b9dy has junk characters how to solve

  • @2010ifyKSA
    @2010ifyKSA Před 3 lety

    U r great 👍🏻
    But if there isn't attachments it still send email 😣
    I want stop it if there's no attachments plz

  • @gabeintothe1106
    @gabeintothe1106 Před rokem

    Can you show how to do this with a "When an item is created or modified" flow ?

  • @corby8678
    @corby8678 Před 3 lety

    Dear Sir
    Please can you make video tutorail on powerapps images gallary and video not display on mobile

  • @ikmalfikri666
    @ikmalfikri666 Před 3 lety +1

    Quick question.
    I want the file submitted in Sharepoint list to run office script..
    The way i do it at the moment is:
    1.Create a file from the Sharepoint Attachment content in Sharepoint FOlder
    2.Run script
    3.Get the completed file content
    4.Add the item to the FileAttachmentContent array
    I have problem at no 4 where it can't send the email using the array.
    Any solution/suggestion?

    • @iamdhruvinshah
      @iamdhruvinshah  Před 3 lety

      Please use the flow I provided as Github link and check again!

    • @ikmalfikri666
      @ikmalfikri666 Před 3 lety

      @@iamdhruvinshah it works if i just want the list attachment..
      but it didn't work if i get file content from another location
      The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: The API operation 'SendEmailV2' is missing required property 'emailMessage/Attachments/0/ContentBytes'.

  • @ivanimmi
    @ivanimmi Před rokem

    Hello, how do I make sure if a list item already has multiple attachments and a user attaches a new attachment to it, that power automate only sends the new attachment in email not attach all attachments in the list item? anyone who can help, thanks in advance

    • @enjoyhub11
      @enjoyhub11 Před 2 měsíci

      Hey @ivanimmi. Did you get any solution for this.???

    • @ivanimmi
      @ivanimmi Před 2 měsíci

      @@enjoyhub11 unfortunately nothing yet. Keep an eye on Microsoft’s new developing feature.

  • @samanthagutierrez6660
    @samanthagutierrez6660 Před 2 lety

    its telling me i haven't entered a valid json but i've copied yours exactly and i dont know where ive gone wrong! please help

    • @misc752
      @misc752 Před 2 lety

      Make sure you have the comma after the first line. Took me sometime to see this🙂

  • @jaspreetsingharora7070
    @jaspreetsingharora7070 Před 4 měsíci

    Great work on this. I have used the same flow with when an item is created or modified but is there a way it can trigger an email only when an attachment is added? If attachment is not added then email is not sent. Thanks.

  • @9246912215
    @9246912215 Před rokem

    Hi Dhruvin, Very nice informative video, can you please provide or make a video on how to send attachments from library to list based on ID of SP List item, thanks in advance...

  • @jhlim
    @jhlim Před rokem

    You r the best Dhruvin! saved me so much time

  • @user-uw6uh2hg6l
    @user-uw6uh2hg6l Před 4 měsíci

    You are the best!