Unanswered

Mass Sending Emails with corresponding attachments for each item using information from excel table

(1) Share

Report

Posted on by JS-30100303-0

Hello good day,

I would like to ask for help on building this workflow. The context is that I have this excel table which have all the information I need to send out an email. I have a column for email addresses, amount, and also a specific file name that matches a file in a sharepoint folder. What I want to happen with this is for example on row 1 to 10 all have the same email address meaning it will be sent to one person only, I do not want to send 10 email messages with 10 different attachments. The goal is to send 1 email message that have a consolidated table of the information from that 10 rows on the email body and attached are the files that are pulled from a sharepoint folder by mapping the file name on the excel file and pulling it from the sharepoint folder.

The part that I am struggling at is pulling the attachments from sharepoint folder and attaching these pulled files into one email message only. I have made it work already for the email body. Mapping the attachment is where I struggle as well as putting it into one email action only

Please help me everything is greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
I can help you get started on this, but I am not sure how to generate the e-mails. Do this as a first step:

Explanation:

The Get items action would be your List rows action to get all of the rows in the spreadsheet.

Use the Select action to get the e-mail addresses from the rows returned.

Use a compose action with a union expression to get all of the unique values. This is the expression: union(body('Select'), body('Select'))

Run the flow up to this point and copy the output of the compose action. Then add the Parse JSON action and you can use the output of the run's compose action to generate the scheme for the parse JSON action.

Point the body of the Parse JSON action to the Apply to each action.

Replace my second Compose action (Compose Email) with another List rows present in a table action and use a filter query to get the rows where the e-mail address in the Excel file equals the e-mail address of the current item in the apply to each.

From here on, I am not sure what you need to do. I am sure it can probably be done, but I've never had the occasion to do what you're asking. If you get this far, post another question specifically asking how to generate the e-mails or maybe someone will post an idea here.

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Sorry, looking at your post and image again, it looks like you already figured out the portion I listed below. So, I guess I am no help 😊 Good luck with the rest.

Was this reply helpful? Yes No
Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

Hi @JS-30100303-0

Without your flow, I am going to assume you already have a loop in there to go over all the 10 rows to get information.

So how do you do your attachments?

Like this

1. Create an Array, that will store the file name and Content

2. in the loop add the filename and content to the array

3. In your Email add the array as the Attachments in a single expression, which is simply your variable output

Example: With the only difference is the example uses Get files to have their loop, you are looping on your excel rows

Send Email with Multiple Attachments from SharePoint Library Docs

if this resolves your issue please Mark the answer as such and maybe a like.

If you have further questions please ask

Was this reply helpful? Yes No
JS-30100303-0 10 on at

Like (0)

Report

Hello @Michael E. Gernaey

Is There a way that power automate can populate the column on this screenshot called Project Name?

Like lets say I will use a column from excel to populate it?

I do not know how to put a "description"? for each files that is uploaded on a folder

Was this reply helpful? Yes No