Sending teams message for planner tasks approaching due date (14d and 30d notifications)

(0) Share

Report

Posted on by Tony_Kuiper

Hi all...

I am looking to create a Teams message that advises when a Planner task is 30 and 14 days away from its due date.

My first issue is that most tasks do not have an assigned due date. I can rectify this manually although it would be preferable to use power automate to check if a task has no due date assigned, then assign a due date being x days from the created date. I've tried this however when using addDays() I lose the "due date" field from the task body.

Do I need to manually key this instead? I've tried filtering the array but it shows all the records that have no duedate field even in the array?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Tony_Kuiper

For that you can write this expression under due date field
addDays(items('Apply_to_each')?['createdDateTime'],3)

[Note : if you don't get the required dynamic content , you can use a compose action in the loop and u will get all the variables there, from that select the desired one and double click , it will get selected , then press ctrl +c to copy it, by this you will get like this items('Apply_to_each')?['createdDateTime'] (Which i have used here in the expression]

This the flow I have used here

1. Get all tasks
2. Loop through each task
2a. Use a condition whether the duedate field is empty or not using the below expression
empty(items('Apply_to_each')?['dueDateTime'])
This will return True or False , then if it is True, we need to update the due date using the above expression as I said [ For demo expression I have made the flow to update the assigned date 3 days from created date]

flow overall

I have ran the flow and I got output like this

Input Task [No due date assigned]

After running flow task is assigned with date 3 days from created date [ created date is today]

Mark it as solution if it helps 🙂

Was this reply helpful? Yes No
Tony_Kuiper 12 on at

Like (0)

Report

I set this up accordingly and thought it worked OK because of no errors. It actually didnt update the date with the function. It gave an error: ActionBranchingConditionNotSatisfied. The execution of template action 'Update_a_task_(V2)' skipped: the branching condition for this action is not satisfied.
When you create the apply to each which value from the tasks list is supposed to be used?

In order to keep moving I ended up just entering the date as a static date, however I would like to get this working for future tasks that are created without a due date being added.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Tony_Kuiper

Could you please share screenshot of error ?

Was this reply helpful? Yes No
Tony_Kuiper 12 on at

Like (0)

Report

There are technically no conditions that will result in a true output, however the message is the identical one as I got before I forced the dates to change.

snip power automa...

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Tony_Kuiper

It seems like the condition is returning false,

Are you using the condition

empty(items('Apply_to_each')?['dueDateTime'])

Was this reply helpful? Yes No
Tony_Kuiper 12 on at

Like (0)

Report

yes I was using that dueDateTime function and the equals to true function.
I got the message when there were no dates set and the same message when dates are all set now.
I did some reading re the same errors with sending to outlook... I wrapped the datetime items (the check if exists and the update the due date with the created plus a value) in formatdatetime().

I then manually deleted a task due date and re ran the flow.

Seems to work now. I suspect it's something to do with the formatDateTime thing?

Was this reply helpful? Yes No
MRChrisEther 2 on at

Like (0)

Report

Hello,

Did anyone resolve this:

I am looking to create a Teams message that advises when a Planner task is 30 and 14 days away from its due date.

...as previously shared by someone else?

Many thanks,
Chris.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Hi @Nived_Nambiar ,
Thanks for the response, learned a new thing through this post. Thanks @Tony_Kuiper for this question.
Just had one small requirement that I wanted your inputs on:
Initially I had created the task named 'Demo' with no Due date and after I ran the flow (manually) it assigned a due date (from 4 days of the current date : 06/02/2024 +4 = 10/02/2024). Now what I want is let's say a user who is the part of this Teams channel (assume channel name: Power Apps) makes a change to the due date let's say changes it 12/02/2024 then once this is done I wanted a comment to be added in the same task stating 'Task_name due date changed to 12/02/2024' and also a notification to be sent to the assignee for that particular task (if there is any).
So if you have any idea about this please let me know

Regards,
Sidhant.

Was this reply helpful? Yes No