Power Automate Send the one Email with Multiple Attachments from SharePoint List

(0) Share

Report

Posted on by joeking

Hi team,

Hoping you can assist.

The below flow gets items from a SharePoint list and attaches the documents from the SharePoint List entry to an email and sends the email.

The issue I have currently, if there is more than one document (attachment), the flow will only attach one attachment at a time and send one email per attachment. So if there is more than one attachment, the client gets more than one email. I would like the flow to send only the one email and that email includes all that clients’ SharePoint List attachments.

EG. the flow looks in a SharePoint List for clients with outstanding payments. If there are any outstanding payments, the flow attaches all the invoices which are saved in that clients SharePoint List entry, and emails that client.

Please let me know if I need to provide any further clarification.
Please see below, and let me know if you need further screen shots.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

So in this scenario, the "Get Items" should be returning all of the files that you want to attach to a single email, is that correct?

Was this reply helpful? Yes No
joeking 67 on at

Like (0)

Report
Copy link

Link copied!

yes, the Get Items and the Condition, is returning the correct files.

the issue is that the flow sends the files in separate emails, and it doesn't send all the files in the one email.

EG. if a client has 2 invoices for outstanding payments, instead of attaching the two invoices into the one email, it sends the two files separately in 2 emails.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @joeking,

You need to initialize a variable as an array to save the multi attachments, then append variable to the array.

Here is a simple demo:

{ "Name": items('Apply_to_each_2')?['DisplayName'], "ContentBytes": body('Get_attachment_content') }

Was this reply helpful? Yes No
joeking 67 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much Qi, I will run some tests and confirm back.
@v-qiaqi-msft

Was this reply helpful? Yes No
joeking 67 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-qiaqi-msft however the flow is still sending one attachment per email. Please see below;

Any suggestions? Have I missed something?

Was this reply helpful? Yes No
joeking 67 on at

Like (0)

Report
Copy link

Link copied!

also, if I move the outlook module from the apply to each, the flows sends multiple email attachments, but these attachments include other SharePoint List/clients documents.

Was this reply helpful? Yes No