cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

adavana_1-1612790297994.png

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-duann-msft
Community Support
Community Support

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:

v-duann-msft_0-1612854908071.png

 

 

This is the whole flow:

v-duann-msft_1-1612854908074.png

 

 

Please check details of flow:

v-duann-msft_2-1612854908083.png

 

 

Apply to each:

v-duann-msft_3-1612854908085.png

 

 

Apply to each 2:

v-duann-msft_4-1612854908088.png

 

 

Apply to each 3:

v-duann-msft_5-1612854908091.png

 

 

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

v-duann-msft_6-1612854908092.png

 

 

v-duann-msft_7-1612854908093.png

 

 

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

View solution in original post

3 REPLIES 3
v-duann-msft
Community Support
Community Support

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:

v-duann-msft_0-1612854908071.png

 

 

This is the whole flow:

v-duann-msft_1-1612854908074.png

 

 

Please check details of flow:

v-duann-msft_2-1612854908083.png

 

 

Apply to each:

v-duann-msft_3-1612854908085.png

 

 

Apply to each 2:

v-duann-msft_4-1612854908088.png

 

 

Apply to each 3:

v-duann-msft_5-1612854908091.png

 

 

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

v-duann-msft_6-1612854908092.png

 

 

v-duann-msft_7-1612854908093.png

 

 

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

View solution in original post

Anonymous
Not applicable

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). 

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

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,330)