Multiple Emails and Multiple Rows

(0) Share

Report

Posted on by pmb124

On my flow I'm using an excel sheet as my data source. I want to be able to send a single email to an email address (that can possibly appear twice) on that sheet containing multiple other columns. For example there can be the same email in multiple rows but I want to be able send an email to the address in the second column to rows 1 and 3. On that email using a HTML table some data such as first and last name of every column that was flagged for email distribution would appear on that single email.

Email	test.test@test.com	Marshall	Erickson
Dont Send	test.test@test.com	Ted	Mosby
Email	test.test@test.com	Lily	Aldrin

Thanks in advance!

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Multiple Emails and Multiple Rows

Hi @pmb124,

You could use the filter query to filter out column1 equals "Email", then send email to the Email store in column 3:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.