Power Automate - How to retrieve SharePoint list attachments and send email?

Sdílet
Vložit
  • čas přidán 1. 08. 2024
  • This video explains how to retrieve SharePoint list attachments and send email.

Komentáře • 50

  • @billybarbarian
    @billybarbarian Před 13 dny +1

    Worked great. Thanks! God bless!

  • @rodrigollaneza
    @rodrigollaneza Před 3 měsíci +1

    Excellent tutorial!!.. Works like a charm :). Thanks for the clear information and step by step procedurest.

  • @bigheadwu1735
    @bigheadwu1735 Před 11 měsíci +1

    Thank you 😊Amazing!!!

    • @abm4975
      @abm4975  Před 10 měsíci

      You're welcome 😊

  • @claycampbell5568
    @claycampbell5568 Před 4 měsíci +1

    Thank You! This works great!!

  • @janosdora8666
    @janosdora8666 Před měsícem +1

    Many thanks for your help! Everything is so helpful.

    • @abm4975
      @abm4975  Před měsícem

      Glad to hear that! Thanks for the wonderful support.

  • @Paul-li7vt
    @Paul-li7vt Před 2 měsíci +1

    Incredible video! Thank you for sharing

    • @abm4975
      @abm4975  Před měsícem

      Glad you enjoyed it!

  • @user-uh1rh2yp1x
    @user-uh1rh2yp1x Před 11 měsíci +1

    Thanks well done!

  • @gotavio
    @gotavio Před 4 měsíci +1

    Works fine here!!

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

      Thanks for the support

  • @ibzkoty
    @ibzkoty Před 6 měsíci +1

    Thanks works well.

  • @lukegatt3218
    @lukegatt3218 Před 6 měsíci +1

    Nice and Simple! I created a different array format to use with a DocuSign connector and add attachments to an envelope.

  • @FaithfulStreaming
    @FaithfulStreaming Před 15 dny

    Do you know how I can create a way to do the following
    1. When an item is created or modified in a sharepoint list
    1a. Filter if a condition is met (if information found in column is not "information Correct" and Email Required column is set to "yes"
    2. Take column information (choices) that has multiple choices inside that column "Correct Information, Address Incorrect, Not Found, Location Incorrect, Panel Closed etc,
    3. Attach a form
    4. Send an email to x
    I want to do this for multiple columns that contain information, and each column has a unique email recipient

  • @taralaya4007
    @taralaya4007 Před 4 měsíci +1

    Superb! it worked like wonder!

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

      Glad it helped! Thanks

  • @meenufsts
    @meenufsts Před 10 dny

    Thanks for helping. I am getting error - Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'For_each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'. while I follow the step and I am getting email with True or False jpg images(not able to open the images also). How can I make it work.

  • @migueldumlao6013
    @migueldumlao6013 Před 9 měsíci +1

    Does this flow also work if i'm trying to attach an outlook email into the power automate email? I used the same flow as you have in this video. When I created a new list item and attached an outlook email into the list item, my flow failed with the following message:
    "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'.

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

      Hi
      This is due to lack of quality of the data. There are no data to map for the To, Subject and Body. I need to look at your flow then only I can give you an exact answer. You can contact me via teams. I could offer a screenshare and check. See my channel about section for my email to contact.
      Thanks

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

      I have the same problem. My flow is all correct. It works normally when I don't include the attachment. Then include the attachment variable, it also gives this error.@@abm4975

  • @rachellim4147
    @rachellim4147 Před 10 měsíci +1

    Thank you for this video.
    I have tried this method to get image file from dataverse table and it keeps back with error " Parameter 'Attachment Name' cannot be null or empty." . Could you please guide me on this ?

    • @abm4975
      @abm4975  Před 10 měsíci

      Hi
      I need to look your flow. Happy to look via a screenshare. Check my Channel about section and connect me via teams.
      Thanks

  • @markjavier4349
    @markjavier4349 Před měsícem +1

    can you do it also for more than one entry? ie multiple ID?

    • @abm4975
      @abm4975  Před měsícem

      Yes you can. Change the trigger step to Get Items. Then pretty much follow the same steps.

  • @aniketsalvi651
    @aniketsalvi651 Před 5 měsíci +1

    Hi thanks for this video . Will this flow work if I attach an .xlxs excel file ? . Actually I tried but it didn’t work

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

      It should

    • @emmanuelwatson93
      @emmanuelwatson93 Před 2 měsíci +1

      @@abm4975 Any ideas how to fix with excel

    • @abm4975
      @abm4975  Před měsícem

      I need to see your flow. Can you connect me? Check my Channel About section.

  • @brianoyando1660
    @brianoyando1660 Před 8 měsíci +1

    Could you create one showing how to Get list attachments and save them in a folder with a unique name?

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

      Apologies for the late reply. I been away for a family emergency. If you still need help in this please let me know.
      Thanks

  • @AshuKumar-lo5vt
    @AshuKumar-lo5vt Před 8 měsíci +1

    How to change "FROM " email address as Microsoft Bot.

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

      Hi
      Not sure what you meant by Bot?
      Thanks

    • @ibzkoty
      @ibzkoty Před 6 měsíci

      In the advanced options of Send an Email V2 you can specify the From address.

  • @Abolsheen
    @Abolsheen Před 3 měsíci +1

    Attachments retrieved but corrupted.

    • @abm4975
      @abm4975  Před měsícem

      Do you still need help in this?

  • @carlosm5591
    @carlosm5591 Před 6 měsíci +1

    Excelent, but i tried pasing an attach file for an approval and it dind't work. I have tu put this in the comose json but i works but the person who received it can't open. It need privileges, it's weird because i'm have total control. Thanks
    {
    "name":DisplayName,
    "content": base64(body('Get_attachment_content'))
    }

    • @abm4975
      @abm4975  Před 5 měsíci +1

      Hi
      I need to see your flow to determine whats going on. I could offer a screenshare and connect me. Check my channel about section.
      Thanks

    • @carlosm5591
      @carlosm5591 Před 5 měsíci +1

      Thanks but finally i found the solution.

    • @palendrenpillay2850
      @palendrenpillay2850 Před 3 měsíci +1

      @@carlosm5591 , would you mind sharing how you solved this? I ran into the same issue as well. The receiver cannot open the file. Many thanks!

    • @abm4975
      @abm4975  Před měsícem

      If you need help in this please connect me via Channel About section. I will have a look. Thanks

    • @carlosm5591
      @carlosm5591 Před měsícem

      @@palendrenpillay2850 Sorry for the delay, i didn't realize the notification:
      What i did is the following: I tried a lot of options and finally i got the result:
      Just remove bytes and left content. Hope don't be late
      {
      "name": @{items('For_each')?['DisplayName']},
      "content": @{body('Get_attachment_content')}
      }