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

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

КОМЕНТАРІ • 53

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

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

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

      Great to hear!

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

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

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

      Very cool!

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

    Incredible video! Thank you for sharing

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

      Glad you enjoyed it!

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

    Many thanks for your help! Everything is so helpful.

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

      Glad to hear that! Thanks for the wonderful support.

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

    Worked great. Thanks! God bless!

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

      Glad it helped

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

      Thanks a lot

  • @julianacsmartins
    @julianacsmartins 24 дні тому +1

    Thanks!

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

    Superb! it worked like wonder!

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

      Glad it helped! Thanks

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

    Thank You! This works great!!

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

      Great to hear!

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

    Works fine here!!

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

      Thanks for the support

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

    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

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

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

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

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

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

    Thanks works well.

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

      Good to hear!

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

    Thank you 😊Amazing!!!

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

      You're welcome 😊

  • @user-uh1rh2yp1x
    @user-uh1rh2yp1x Рік тому +1

    Thanks well done!

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

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

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

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

      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 11 місяців тому +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  11 місяців тому

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

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

      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 9 місяців тому

      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

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

      It should

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

      @@abm4975 Any ideas how to fix with excel

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

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

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

    Attachments retrieved but corrupted.

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

      Do you still need help in this?

  • @AshuKumar-lo5vt
    @AshuKumar-lo5vt 10 місяців тому +1

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

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

      Hi
      Not sure what you meant by Bot?
      Thanks

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

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

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

      Thanks but finally i found the solution.

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

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

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

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