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?
Solved! Go to Solution.
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.
P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.