Create Flow to Send Email for each row in excel table

[vnardo]

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

[v-bofeng-msft]

Hi @vnardo :

Please try:

Best Regards,

Bof