Answered

Using Power Automate to send task due reminders to email from planner.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi - fairly new to power automate. I have planner tasks that once they've been assigned to staff, need an email to go that individual day before a task is due, 3 days out, and 7 days out.

I know I need it to be a scheduled flow that runs daily to check the planner list. Help with the set up please? Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

SamLed 2,340 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi Renazuki,

Planner already manage some notification about due date: Manage Planner notifications - Microsoft Support

But if you don't find it enough, here how I would design the flow:
Use a schedule trigger set up to run every day at 7:00 am, before guys open their outlook.
Get list of task using "List tasks" action
For each task, check Due date using conditions action:
if 1 day before Due date using expression: addDay("Due date", -1), 'yyyy-MM-dd') equals formatDateTime(utcNow(), 'yyyy-MM-dd'). send mail if true.
if 3 day past due date using expression: addDay("Due date", +3), 'yyyy-MM-dd') equals formatDateTime(utcNow(), 'yyyy-MM-dd'). send mail if true.
if 7 day past due date using expression: Check if addDay("Due date", +7), 'yyyy-MM-dd') equals formatDateTime(utcNow(), 'yyyy-MM-dd'). send mail if true.

That's all folks ! 😉
_____________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

It's kicking back an error message:
Error
Action 'Apply_to_each_2' failed
Error Details:
The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_3')?['dueDateTime']' is of type 'String'. The result must be a valid array.

Was this reply helpful? Yes No
Verified answer

SamLed 2,340 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

I can't help you regarding this error without viewing your flow, but I've build a flow that you should like, to illustrate my first reply, here is complete view:

Let's see details:
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

Thank you very much. ^^ This was very helpful for me as a newbie with the power automate. My team has the reminders in planner turned off and the due dates are more for external reminders - tasks that are done by others outside of our team, like inspections.
Have a fabulous rest of the day ~

Was this reply helpful? Yes No