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!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
User | Count |
---|---|
74 | |
20 | |
17 | |
14 | |
13 |
User | Count |
---|---|
127 | |
35 | |
31 | |
28 | |
25 |