SharePoint list attachment link via flow

(0) Share

Report

Posted on by Oliandril

Hi everyone,

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

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.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

v-bacao-msft on at

Like (3)

Report
Hi @Oliandril,

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

Use Get attachments action to get the attachment file absoluteUri.

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.

Finally, the variables are configured in the Body.

Image reference:

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

Was this reply helpful? Yes No
Oliandril 61 on at

Like (0)

Report

Thank you Barry!

I tried your propose like this, because otherwise I get no complete HMTL Link:
next step is to get the Link into an approval mail (with options):

Unfortunately, the result in the email looks like this:

The links are finally working, but I like to format the text for our management.
How can this be solved?

Thank you, Thomas

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

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

Was this reply helpful? Yes No
Oliandril 61 on at

Like (0)

Report

Hi Barry,

the sent e-mail should look like this:

/Thomas

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (2)

Report

Hi @Oliandril,

You could improve Append to string variable action as follows:

Please take a try again.

Best Regards,

Barry

Was this reply helpful? Yes No
Oliandril 61 on at

Like (0)

Report

Hey Barry,
great work! Thank you so much.
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!!!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Oliandril 61 on at

Like (1)

Report

Hi Edgar,
you can have up to 6 attachments.
The file links are displayed in html.
This is my flow to include the files:

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

Hope my explanation helps.
Thomas

Was this reply helpful? Yes No
mthompson 43 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,
I saw and it worked for me when i try to sent in an email the name of that attachment on the list, but what haapend or how can i do if the item on the list have multiple attchments?

Was this reply helpful? Yes No