Hi all,
I'm building a flow to send automatic notifications to my clients about past due invoices. The information is kept in Excel online file is the following format:
| Client | Email | Invoice Num | Invoice Amt | Due Date |
| A | A@randomemail.com | Inv-1 | 5 | 18 Jun 2021 |
| B | B@randomemail.com | Inv-2 | 10 | 01 Feb 2021 |
| A | A@randomemail.com | Inv-3 | 11 | 05 May 2021 |
I want to send a reminder to client A but, as you can imagine, I wish to send only 1 email to client "A" which will contain a table with 2 invoices he should pay.
So far I've found how to send email for each row using "Apply to each", but in that case client "A" gets 2 emails, each of them containing details for a relative row.
Any suggestions how to solve it?
Thank you!