Forum Discussion
sharadbajaj
Jan 29, 2022Copper Contributor
Send Email Reminders Through Power Automate
Hi,
Request your help with the following task:
Need to send Daily Reminders with pending tasks to the individual. I was able to send individual emails for each item, however would like to send 1 email to each user with list of all their pending items.
My data is stored in Excel Online.
SL No | Department | Task | Owner | Status | Email Address |
1 | Finance | Task 1 | ABC | Done | Email address removed |
2 | Finance | Task 2 | ABC | Pending | Email address removed |
3 | Operations | Task 3 | XYZ | Pending | Email address removed |
4 | Operations | Task 4 | XYZ | Pending | Email address removed |
5 | Operations | Task 5 | XYZ | Done | Email address removed |
6 | Finance | Task 6 | ABC | Pending | Email address removed |
Eg. ABC should get an email of SL No 2 and 6 (in 1 email) and XYZ should get an email of SL 3 and 4.
- Sudharsan KSteel Contributor
Hi sharadbajaj, once you got the items follow the steps below
- Create an array variable for storing all the Owners
- Loop through the items and then store all the Owners in the above array variable.
- Use Union method with the above array variable to get the unique Owners and store it on the same variable.
- Using apply with the Owners array variable, use the filter action with the items and then filter for each owner and send the consolidate list to the respective owner.
Please try it out and let me know if you have any clarifications.
- sharadbajajCopper ContributorHi Sudarshan,
I have been unable to do this. Can you please help me with a detailed tutorial or point me to a already existing one.