cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vnardo
Regular Visitor

Create Flow to Send Email for each row in excel table

I am trying to create a flow using power automate to send the data in each row of an excel table as a separate email based on the user email in each for of the table.

 

My table is setup like this;

vnardo_0-1641753033569.png

I want to reach each row and then send the details for each column of the table. I prefer to send it as an HTML table within the body of the email.

 

I have my flow setup like this;

 

vnardo_1-1641753143408.png

 

However, instead of one email for each row, each email has all the rows of data?

vnardo_3-1641753423132.png

 

 

I also need to reformat the values in the HTML table as they are coming out without the number formats that exist in the excel table (IE: the GCR/Prior Month should be formatted as a percentage, not a decimal).

 

Any assistance is appreciated!!

 

 

 

 

 

 

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @vnardo :

Please try:

vbofengmsft_0-1641954425012.png

Best Regards,

Bof

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,105)