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 | 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!
Solved! Go to 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
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 😉
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
66 | |
27 | |
22 | |
15 | |
14 |
User | Count |
---|---|
128 | |
47 | |
44 | |
34 | |
31 |