
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.
| test.test@test.com | Marshall | Erickson | |
| Dont Send | test.test@test.com | Ted | Mosby |
| test.test@test.com | Lily | Aldrin |
Thanks in advance!
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.