Unanswered

Send reminder by selecting similar item

(0) Share

Report

Posted on by Community Power Pla...

Hi Team,

I have a list (Image below) and am I able to put Power Automate so it will send email reminder to the users in Supervisor and User Column once a day, if the duedate is 7days less and equal to today's date and Status is 'Not Started' by matching the department.

If a department is same and Supervisor and user are same then select all the title and send it in one email.

Eg .

To : Ca

CC : H, Vi, Rep

Subject : Department Name

List of test not started:

Test 1

Test 2

If a user is different but have same department then separate emails with the title.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Hi there,

You would use the "Get Items" function with your filters, just as before, but then you can use the "Create HTML Table" action to look at your values from the "Get Items", and then send that table in the email. That's the easiest, fastest way, I believe!

R

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Would you be able to design it and show with the steps?

I'm new to Power Automate.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

I just noticed in your request that you only want to group things if the User, Department AND Supervisor are all the same? That's a bit different.

First, you'd Get Items with the same Filter Query you have right now - the 7 days away from due date, equal to Not Started. You've already done that in your flow.

But now you're going to need to filter the array for each user. Are there any assumptions we can make? Does the user always have the same supervisor? Is the supervisor always tied to the same department? Anything like that? Please let me know so we can make it streamlined.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The Department and their Supervisor will always tied to each other.
But users can be different in each row.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

??

Was this reply helpful? Yes No