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