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