web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email the table conten...
Power Automate
Unanswered

Email the table content based on excel content condition

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
 

sample.PNG

this is the data: trying to build a flow.

 

1. For every change in ID, an email need to be sent to email in the email column (which will be unique for any ID set)

2. The email body to have table with data related to respective ID entry. ex for ID001 : first three rows of amount, sum should be populated as table with header.

3. Grand total value should be shown outside the table to be used anywhere in email body. ex: for ID001 : 40+50+60 =150

4. Same as point 3. Name should be available to use any where in the body for an ID set. Name will be unique too.

 

So far I am able to repeat the steps using union for change in email (refer below image) - but stuck with ID.

sample1.PNG

 

Thanks.

Categories:
I have the same question (0)

Under review

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

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 469

#3
11manish Profile Picture

11manish 364

Last 30 days Overall leaderboard