Email multiple excel rows grouped per email

Like (0) Share

Report

Posted on 31 Jan 2023 15:26:51 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.

All responses (3)

Answers (1)

ryule 929 Super User 2024 Season 1 on 01 Feb 2023 at 15:40:32

Like (1)

Report

Re: Email multiple excel rows grouped per email

You're welcome; let me know if you have any questions on it!
RR-27091314-0 71 on 01 Feb 2023 at 10:59:15

Like (1)

Report

Re: Email multiple excel rows grouped per email

Hey @ryule,

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

ryule 929 Super User 2024 Season 1 on 31 Jan 2023 at 16:11:18

Like (0)

Report

Re: Email multiple excel rows grouped per email

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.