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

Report
All responses (
Answers (