Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Inserting customized table in email from Excel file

Posted on by

Hello!

 

I am trying to create a flow wherein once an Excel file has been updated in Sharepoint, the flow will send an email to each of the email addresses in the Excel table. The content of the email will be a table showing the breakdown of outstanding balance for each individual. Below is a sample table.

jiniistrawberii_0-1721026727265.png

I have two individuals with two different email addresses. Since there are two individuals in my sample - John and Jane - there should be two emails sent to each address. However, for Jane, since she has two outstanding balances, both balances should be indicated in the table. Below is the rough format of the email that I want.\

 

For John:

jiniistrawberii_1-1721026983980.png

For Jane:

jiniistrawberii_2-1721027024838.png

 

This is the flow I have so far.

jiniistrawberii_3-1721027267015.pngjiniistrawberii_4-1721027285044.pngjiniistrawberii_5-1721027312993.png

 

Now, although I have been able to successfully insert a table in the email. However, the table shows all the data in the Excel file.

jiniistrawberii_7-1721028070211.png

As shown in the snippet, all three items are listed on the table when it should only be the August bill for John.

 

Is there any way for me to do it so that I can send a specified email to each of the addressees?

Thank you!!

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1