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

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 พ.ย. 2024

ความคิดเห็น • 62

  • @lukegatt3218
    @lukegatt3218 9 หลายเดือนก่อน +1

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

    • @abm4975
      @abm4975  8 หลายเดือนก่อน

      Very cool!

  • @rodrigollaneza
    @rodrigollaneza 6 หลายเดือนก่อน +1

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

    • @abm4975
      @abm4975  5 หลายเดือนก่อน

      Great to hear!

  • @efmchale
    @efmchale 20 วันที่ผ่านมา +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  19 วันที่ผ่านมา

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

  • @janosdora8666
    @janosdora8666 4 หลายเดือนก่อน +1

    Many thanks for your help! Everything is so helpful.

    • @abm4975
      @abm4975  4 หลายเดือนก่อน

      Glad to hear that! Thanks for the wonderful support.

  • @Paul-li7vt
    @Paul-li7vt 5 หลายเดือนก่อน +1

    Incredible video! Thank you for sharing

    • @abm4975
      @abm4975  5 หลายเดือนก่อน

      Glad you enjoyed it!

  • @billybarbarian
    @billybarbarian 3 หลายเดือนก่อน +1

    Worked great. Thanks! God bless!

    • @abm4975
      @abm4975  3 หลายเดือนก่อน

      Glad it helped

    • @abm4975
      @abm4975  3 หลายเดือนก่อน

      Thanks a lot

  • @andystrang8831
    @andystrang8831 หลายเดือนก่อน +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  หลายเดือนก่อน

      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

  • @joanvarela9536
    @joanvarela9536 หลายเดือนก่อน +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  หลายเดือนก่อน

      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

  • @taralaya4007
    @taralaya4007 7 หลายเดือนก่อน +1

    Superb! it worked like wonder!

    • @abm4975
      @abm4975  7 หลายเดือนก่อน

      Glad it helped! Thanks

  • @gotavio
    @gotavio 8 หลายเดือนก่อน +1

    Works fine here!!

    • @abm4975
      @abm4975  8 หลายเดือนก่อน

      Thanks for the support

  • @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 11 หลายเดือนก่อน

      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

  • @markjavier4349
    @markjavier4349 4 หลายเดือนก่อน +1

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

    • @abm4975
      @abm4975  4 หลายเดือนก่อน

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

  • @claycampbell5568
    @claycampbell5568 7 หลายเดือนก่อน +1

    Thank You! This works great!!

    • @abm4975
      @abm4975  7 หลายเดือนก่อน

      Great to hear!

  • @liguimbodj
    @liguimbodj ปีที่แล้ว +1

    Thanks well done!

    • @abm4975
      @abm4975  ปีที่แล้ว

      Thank you too!

  • @bigheadwu1735
    @bigheadwu1735 ปีที่แล้ว +1

    Thank you 😊Amazing!!!

    • @abm4975
      @abm4975  ปีที่แล้ว

      You're welcome 😊

  • @ibzkoty
    @ibzkoty 9 หลายเดือนก่อน +1

    Thanks works well.

    • @abm4975
      @abm4975  9 หลายเดือนก่อน

      Good to hear!

  • @FaithfulStreaming
    @FaithfulStreaming 3 หลายเดือนก่อน

    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

  • @aniketsalvi651
    @aniketsalvi651 8 หลายเดือนก่อน +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  7 หลายเดือนก่อน

      It should

    • @emmanuelwatson93
      @emmanuelwatson93 5 หลายเดือนก่อน +1

      @@abm4975 Any ideas how to fix with excel

    • @abm4975
      @abm4975  5 หลายเดือนก่อน

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

  • @meenufsts
    @meenufsts 3 หลายเดือนก่อน

    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.

  • @brianoyando1660
    @brianoyando1660 11 หลายเดือนก่อน +1

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

    • @abm4975
      @abm4975  8 หลายเดือนก่อน

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

  • @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

  • @julianacsmartins
    @julianacsmartins 2 หลายเดือนก่อน +1

    Thanks!

    • @abm4975
      @abm4975  2 หลายเดือนก่อน

      No problem!

  • @AshuKumar-lo5vt
    @AshuKumar-lo5vt 11 หลายเดือนก่อน +1

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

    • @abm4975
      @abm4975  11 หลายเดือนก่อน

      Hi
      Not sure what you meant by Bot?
      Thanks

    • @ibzkoty
      @ibzkoty 9 หลายเดือนก่อน

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

  • @coraguerrier5732
    @coraguerrier5732 3 วันที่ผ่านมา

    This doesn't work for me. :(

  • @Abolsheen
    @Abolsheen 6 หลายเดือนก่อน +1

    Attachments retrieved but corrupted.

    • @abm4975
      @abm4975  5 หลายเดือนก่อน

      Do you still need help in this?

    • @daniellemariano1228
      @daniellemariano1228 หลายเดือนก่อน

      I need 😢

    • @abm4975
      @abm4975  หลายเดือนก่อน

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

  • @carlosm5591
    @carlosm5591 9 หลายเดือนก่อน +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  8 หลายเดือนก่อน +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 8 หลายเดือนก่อน +1

      Thanks but finally i found the solution.

    • @palendrenpillay2850
      @palendrenpillay2850 6 หลายเดือนก่อน +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  5 หลายเดือนก่อน

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

    • @carlosm5591
      @carlosm5591 5 หลายเดือนก่อน

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