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.
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:
For Jane:
This is the flow I have so far.
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.
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!!
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1