Send Email Reminders Through Power Automate

[sharadbajaj]

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.

[#2]

Hi @sharadbajaj, once you got the items follow the steps below

1. Create an array variable for storing all the Owners
2. Loop through the items and then store all the Owners in the above array variable.
3. Use Union method with the above array variable to get the unique Owners and store it on the same variable.
4. 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.

[#3]

Hi 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.