Showing results for 
Search instead for 
Did you mean: 
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;


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;




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




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!!







Community Support
Community Support

Hi @vnardo :

Please try:


Best Regards,



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,552)