Answered

Email multiple excel rows grouped per email

(0) Share

Report

Posted on by RR-27091314-0

I have an excel sheet where each row can contain unique data but the recipient could be the same for multiple rows.

I am trying to create a flow that will loop through each row to create a list and then send this as one email per email address in Column J.

I have managed to create the following which does create a list of all entries grouped by email, clears the list and then repeats for the next email address however i don't know how to have the flow sent the list to the 1st email before wiping and starting the process again for the 2nd email address, any help appreciated and i'm new to POW AUTO DESKTOP so detailed help would be appreciated.

Categories:

Power Automate Desktop

I have the same question (1)

All responses (3)

Answers (1)

Sort by

Verified answer

ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I do this same exact thing for a few bots.
You first need to create a list of emails out of your Excel data and remove duplicates, something like this:

Then loop through this list, and then your loop within this loop will look for rows with matches on the email

Here's mine, where it loops through the list of emails, and in my case, instead of adding each to a list, I'm building out an HTML table in a variable. And then not pictured, but at the end of the "For each email" loop, is a Send Email action.

Was this reply helpful? Yes No
RR-27091314-0 71 on at

Like (1)

Report
Copy link

Link copied!

Hey @ryule,

Thank you for the reply and guidance it was very helpful.

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You're welcome; let me know if you have any questions on it!

Was this reply helpful? Yes No