You’re offline. This is a read only version of the page.
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.
??
The Department and their Supervisor will always tied to each other.
But users can be different in each row.
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.
Would you be able to design it and show with the steps?
I'm new to Power Automate.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
