Answered

Send emails to multiple receipents including table (data from excel)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am building a flow to send emails to receipients who email ids along with data saved in an excel on one drive. I have earlier built flows to extract data and compose in html table formats and send as emails:

check the below data

The flow I am trying to prepare should:

- send one email to each unique email id and in body it should include data from column 3,4,5 in the table format. ( n batches of unique email receipents, one email for each)

Thanks!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

v-duann-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you for posting.

According to your description, you want to send single email to each person including table. If that’s the case, we need to combine variable action and union formula to achieve your purpose.

Here is my excel by the way:

This is the whole flow:

Please check details of flow:

Apply to each:

Apply to each 2:

Apply to each 3:

Once we run the flow, the records with same email address will be extracted and put into table and sent to the right person:

For more information, you can also refer below forums:
https://powerusers.microsoft.com/t5/Building-Flows/Sending-Scheduled-Emails-with-Excel-Rows-Included/m-p/593729

Hope the content above may help you.

Thanks
Anna
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Anna, @v-duann-msft

Thanks for the solution flow. It really solved my blocker.

How to mention the name value (in your excel/output its 'B') outside the table in the body email as dynamic content - and how can we sum the price column (can be outside the table as independent value).
LucianM 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @Anonymous !

have you found a solution for summing the price column? in or out of the table, it doesn't matter 🙂
I'm very interested too.

Anna / @v-duann-msft , can you help us with a solution?

Thank you!
Lucian