cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oliandril
Level: Powered On

SharePoint list attachment link via flow

Hi everyone,

I would like to send multiple attachments from a sharepoint-list via email and I don´t know how to handle this:

list.jpg

The first entry has 3 attachments. So I like to get the link from them via flow and send the linkinformation in one Mail. I tried different times but nothing worked.

I know that I can use a link field in this sharepoint list. But thats not the optimal solution.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: SharePoint list attachment link via flow

Hi @Oliandril,

 

You could improve Append to string variable action as follows:

22.PNG23.PNG

Please take a try again.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
Community Support Team
Community Support Team

Re: SharePoint list attachment link via flow

Hi @Oliandril,

 

You could use the String variable to store the attachment link.

  1. Use Get attachments action to get the attachment file absoluteUri.
  2. Configure Apply_to_each to iterate through all the attachment files contained in the item, then append the Uri to String variable, preferably adding a newline.
  3. Finally, the variables are configured in the Body.

Image reference:

9.PNG10.PNG

In addition, if you want to send the attachments contained in the item, you could refer to the following link:

https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oliandril
Level: Powered On

Re: SharePoint list attachment link via flow

Thank you Barry!

 

I tried your propose like this, because otherwise I get no complete HMTL Link:

Capture.JPG

next step is to get the Link into an approval mail (with options):

 

Capture.JPG 

 

Unfortunately, the result in the email looks like this:

Capture.JPG

 

The links are finally working, but I like to format the text for our management.

How can this be solved?

 

Thank you, Thomas

 

Highlighted
Community Support Team
Community Support Team

Re: SharePoint list attachment link via flow

Hi @Oliandril,

 

Can you provide specific format?

I don't know what format you need, I can't start.

Please provide specific examples.

 

Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oliandril
Level: Powered On

Re: SharePoint list attachment link via flow

Hi Barry,

 

the sent e-mail should look like this:

 

Capture.JPG

 

/Thomas

 

Community Support Team
Community Support Team

Re: SharePoint list attachment link via flow

Hi @Oliandril,

 

You could improve Append to string variable action as follows:

22.PNG23.PNG

Please take a try again.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Oliandril
Level: Powered On

Re: SharePoint list attachment link via flow

Hey Barry,

great work! Thank you so much.  Smiley Very Happy

I didn´t know that you can use html to format the email even in a string variable.

Good to know.

This solution could be very interesting for many companys and flows!!!

 

Capture.JPG

 

 

edgar3tres
Level: Powered On

Re: SharePoint list attachment link via flow

what if you have more than 2 attachments? Also, is there a way to get this links into a html file to see the pictures attached?

Oliandril
Level: Powered On

Re: SharePoint list attachment link via flow

Hi Edgar,

you can have up to 6 attachments.

The file links are displayed in html.

This is my flow to include the files:

 

Capture.JPG

 

Capture.JPG

Capture.JPG

Please bear in mind that you have set the email option "send as html"=yes

 

Hope my explanation helps.

Thomas

mthompson
Level: Powered On

Re: SharePoint list attachment link via flow

Hello everyone,

I created an approval flow (Send email with Options) from a SharePoint list that is triggered when new item is created.  The email contains multiple attachments (invoice and backup) for Approver to review. Approver is to Approve or Reject attachments for payment. I need to capture Approver comments when rejected so that the "Created By" knows what to change or correct when rejected so they can resubmit for approval.  Also need to resend this request (Schedule for one day reminder) in the event the approver does not approve/reject within a day's time.  Any assistance on the best way to achieve these flow tasks?  End result is for all requests to be approved for payment.

Thanks,

Michelle

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 276 members 6,560 guests
Recent signins:
Please welcome our newest community members: