Answered

Send table in email previously filtered by another column

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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 😉

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No