Answered

Send an email from excel file with Power Automate

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear experts,

I am new to PAD an I have created an automated flow that sends an email for each row, but as most of the IDs are repeated in the rows, each of them would receive more than 1 email. What I need is to be able to send one email for each "requisitioner", listing all the "blocked invoices" I have under his name.

Thank you in advance!

Help PA 1.png Help PA 2.png

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

This is not PAD. This is PA flows (cloud). The D in PAD is for Desktop, and the interface looks much different.

In PAD, we handle this by identifying the filenames on each row and then have a logic similar to the following:

For each row in Excel

Add attachment to %Attachments%

If the next email does not match this email

Send Email with %Attachments%

Clear list %Attachments%

End (if)

End (for each)

This basically adds up all the filenames in a list called %Attachments% and analyzes the next row to see if the email is the same. If it's the same, it adds the next one, but if it is not the same, then it sends out 1 email with all the attachments, then clears the attachments list.

In order for this to be successful, the Excel file has to be sorted by the 'email to' field.

Good luck!

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

Like (0)

Report
Copy link

Link copied!

Thank you very much for your answer, but as you said, I'm not using PAD but PA flows. Do you have suggestions on how to use this same logic there?

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Would it be possible to share a sample file to get an idea how to do and how to acheieve it ?

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

Like (0)

Report
Copy link

Link copied!

This is the structure of the excel file, what I need is to send, for example, a single email to Lara containing all the invoices I have under her name.

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

You can try this way.

I have created a table for demo purpose like below

Flow is designed like below

1. List all rows present in the table

2. Select the email from the values which is output from List rows in tableaction.

3. Use apply to each loop to loop through each unique values of email like below

expression: union(body('Select_emails_'),body('Select_emails_'))

4. Inside the loop follow below steps

4.1 Filter the value with email = current iteration email

4.2 Now create HTML table out of filter array like below

Here i am only considering Invoice num in table. You can other column if you need here , then use the output from create HTML table to be send via email.

Hope it helps 🙂
Mark it as solution if it resolves your query 🙂

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

Like (0)

Report
Copy link

Link copied!

In the free version of Power Automate that I'm using I don't have the variables "Select emails" and " Filter values with each email value". Which version are you using? Thank you very much.

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I am using developer version which is provided for learning purposes

Was this reply helpful? Yes No