Send table in email previously filtered by another column

[Serg24]

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!

[DamoBird365]

Hi @Serg24 

Can you share a screenshot of your flow so that we can explain?

I’ve an article on something similar here https://www.damobird365.com/easily-send-email-mail-merge-with-attachments/ it might help you too.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

[Paulie78 · Accepted solution]

Hi @Serg24 

I also did a video response to another forum user, which explains what you are trying to do:

https://www.youtube.com/watch?v=bS4eV_9hK9o

Paul