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

Поділитися
Вставка
  • Опубліковано 2 гру 2024

КОМЕНТАРІ • 65

  • @cherri_p
    @cherri_p 27 днів тому

    You are a life saver. I have been trying to attach the document from a list library that was running on a daily recurrence to include the list items and attachments in an email. You demonstration was very simple and easy to add to the flow that I had already created to get the list items.

  • @efmchale
    @efmchale Місяць тому +1

    This is awesome!!
    What if I wanted to update an indicator stating the email had already been sent without causing an infinite loop?
    Where would I put the condition to initially test for the indicator, and how would I update it?

    • @abm4975
      @abm4975  Місяць тому

      Thanks for your comment. I didn't get your question regarding the infinite loop? Tell me bit more about this.
      Thanks

  • @lukegatt3218
    @lukegatt3218 10 місяців тому +1

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

    • @abm4975
      @abm4975  9 місяців тому

      Very cool!

  • @euzus
    @euzus 12 днів тому

    Hi, is it working with "sent a notification by e-mail (V3)"?

  • @andystrang8831
    @andystrang8831 2 місяці тому +1

    This is great thanks. One issue - when my email sends, the attachments become unformatted- so if it was a PDF it comes as a big blob of characters rather than retaining the original format. For a text file I get all the markup showing like

    \. What am I missing?

    • @abm4975
      @abm4975  2 місяці тому

      Hi Andy
      I need to see the flow to determine what's going on. Check my channel about section and connect me via email. I could check via a screenshare and see.
      Thanks

  • @migueldumlao6013
    @migueldumlao6013 Рік тому +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  Рік тому

      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 Рік тому

      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

  • @joanvarela9536
    @joanvarela9536 2 місяці тому +1

    Hello excellent tutorial, I just tried the flow exactly as you have it. It currently runs successfully but I'm not getting the actual attachment on the email. The attachment type for my share point list is a "word" document. I'm just getting the email with no attachment, any feedback?

    • @abm4975
      @abm4975  2 місяці тому

      Hi
      Thanks for your kind comments. I need to see the flow. You can connect me via email. Its in my Channel about section. Send me an email and I could check this via a screeshare if that helps.
      Thanks

  • @markjavier4349
    @markjavier4349 5 місяців тому +1

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

    • @abm4975
      @abm4975  5 місяців тому

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

  • @chairattangthong
    @chairattangthong 22 дні тому

    thank you so much Teacher

  • @billybarbarian
    @billybarbarian 4 місяці тому +1

    Worked great. Thanks! God bless!

    • @abm4975
      @abm4975  4 місяці тому

      Glad it helped

    • @abm4975
      @abm4975  4 місяці тому

      Thanks a lot

  • @FaithfulStreaming
    @FaithfulStreaming 4 місяці тому

    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

  • @rodrigollaneza
    @rodrigollaneza 7 місяців тому +1

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

    • @abm4975
      @abm4975  6 місяців тому

      Great to hear!

  • @janosdora8666
    @janosdora8666 5 місяців тому +1

    Many thanks for your help! Everything is so helpful.

    • @abm4975
      @abm4975  5 місяців тому

      Glad to hear that! Thanks for the wonderful support.

  • @Paul-li7vt
    @Paul-li7vt 6 місяців тому +1

    Incredible video! Thank you for sharing

    • @abm4975
      @abm4975  6 місяців тому

      Glad you enjoyed it!

  • @brianoyando1660
    @brianoyando1660 Рік тому +1

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

    • @abm4975
      @abm4975  9 місяців тому

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

  • @meenufsts
    @meenufsts 4 місяці тому

    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.

  • @aniketsalvi651
    @aniketsalvi651 9 місяців тому +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  8 місяців тому

      It should

    • @emmanuelwatson93
      @emmanuelwatson93 6 місяців тому +1

      @@abm4975 Any ideas how to fix with excel

    • @abm4975
      @abm4975  6 місяців тому

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

  • @bigheadwu1735
    @bigheadwu1735 Рік тому +1

    Thank you 😊Amazing!!!

    • @abm4975
      @abm4975  Рік тому

      You're welcome 😊

  • @taralaya4007
    @taralaya4007 8 місяців тому +1

    Superb! it worked like wonder!

    • @abm4975
      @abm4975  8 місяців тому

      Glad it helped! Thanks

  • @claycampbell5568
    @claycampbell5568 8 місяців тому +1

    Thank You! This works great!!

    • @abm4975
      @abm4975  8 місяців тому

      Great to hear!

  • @rachellim4147
    @rachellim4147 Рік тому +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  Рік тому

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

  • @ibzkoty
    @ibzkoty 10 місяців тому +1

    Thanks works well.

    • @abm4975
      @abm4975  10 місяців тому

      Good to hear!

  • @gotavio
    @gotavio 9 місяців тому +1

    Works fine here!!

    • @abm4975
      @abm4975  9 місяців тому

      Thanks for the support

  • @liguimbodj
    @liguimbodj Рік тому +1

    Thanks well done!

  • @julianacsmartins
    @julianacsmartins 3 місяці тому +1

    Thanks!

    • @abm4975
      @abm4975  3 місяці тому

      No problem!

  • @AshuKumar-lo5vt
    @AshuKumar-lo5vt Рік тому +1

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

    • @abm4975
      @abm4975  Рік тому

      Hi
      Not sure what you meant by Bot?
      Thanks

    • @ibzkoty
      @ibzkoty 10 місяців тому

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

  • @coraguerrier5732
    @coraguerrier5732 Місяць тому

    This doesn't work for me. :(

  • @Abolsheen
    @Abolsheen 7 місяців тому +1

    Attachments retrieved but corrupted.

    • @abm4975
      @abm4975  6 місяців тому

      Do you still need help in this?

    • @daniellemariano1228
      @daniellemariano1228 2 місяці тому

      I need 😢

    • @abm4975
      @abm4975  2 місяці тому

      Hi @daniell
      Check my channel about section for my email. I will have a look via screenshare.
      Thanks

  • @carlosm5591
    @carlosm5591 10 місяців тому +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  9 місяців тому +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 9 місяців тому +1

      Thanks but finally i found the solution.

    • @palendrenpillay2850
      @palendrenpillay2850 7 місяців тому +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  6 місяців тому

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

    • @carlosm5591
      @carlosm5591 6 місяців тому

      @@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')}
      }