Answered

Send a reminder email for 30 days and 15 days before deadline for planner tasks

(0) Share

Report

Posted on by simplyjojo76

I am a newbie... trying to build an Automate flow to send reminder emails 15 days before deadline to Planner task assignees. Pls advise as I am encountering this error message. Thank you in advance.

Screenshot 1.jpg Screenshot 2.jpg Screenshot 3.jpg Screenshot 4.jpg

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @simplyjojo76

The worklow is failing because in some cases the due date column in the planner taks is empty or null. In order to avoid that, you could use the following expression:

coalesce(items('apply_to_each')?['dueDateTime'],utcNow())

Coalesce function returns the first non-null value (so, if dueDateTime is null, current date time (utcNow) is returned).

Hope it helps!

Ferran

Was this reply helpful? Yes No
simplyjojo76 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @fchopo ,
Thank you for replying and advise.
Is it possible to add 2 different notifications (eg. 15 days and 30 days before expiry) into same flow or separate them ? As I still trying to pick up on power automate as I use it.

Thank you in advance.

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @simplyjojo76

You could run a workflow everyday, and check which tasks are going to expire in 15 days, and then do the same that are going to expire in 30 days. You can have a look at the following template to get an idea: Send a digest email of all outstanding Planner tasks | Microsoft Power Automate

In the screenshot you provided, it seems it's going to send a notification for every single delayed task.

Hope it helps!
Ferran

Was this reply helpful? Yes No