SharePoint list attachment link via flow

[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.

[v-bacao-msft]

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:

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

[Oliandril]

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

[v-bacao-msft]

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

[Oliandril]

Hi Barry,

the sent e-mail should look like this:

/Thomas

[v-bacao-msft · Accepted solution]

Hi @Oliandril,

You could improve Append to string variable action as follows:

Please take a try again.

Best Regards,

Barry

[Oliandril]

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!!!

[edgar3tres]

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]

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

[mthompson]

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

[Jovalles]

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?

[mthompson]

You would need to create a form that allows attachments (see example below) and within the Flow utilize get attachments and initialize variable (attachment array).

In my scenario the above form is completed with multiple attachments (pdf, Word or Excel files). After submitting the form - the Flow is triggered, sending the attached docs to the requested approver for review and approval.