Mark a Planner task as completed when the due date passed

[tomjedig]

Hello everyone, I want to create a Flow that marks Planner tasks as completed if the due-date is passed.
I made this now but it doesn't mark tasks that were due yesterday as completed.

The condition is:
if due date is equal to addDays(utcNow(),1,'yyyy-MM-dd')

Thanks for your help 🙂

[ChristianAbata]

hi @tomjedig  please try with this fuction with an hour getFutureTime(5,'Hour','yyyy-MM-ddThh:mm:ss') or add to your fuction an hour

[tomjedig]

@ChristianAbata Is that to make it 5 hours ahead? I want the Flow to mark the task if 24 hours passed, eg. the task is due on the 26th and it marks it on the 27th.

[ChristianAbata]

shure @tomjedig  you can change it by 24, see

[efialttes]

Hi!
You can try by replacing 'equals' operator and using 'contains' instead, keeping your current expression as it is right now
Hope this helps

[tomjedig]

Unfortunately @ChristianAbata's suggestion doesn't work and I can't find any errors.

For efialttes suggestion I have an error 

[efialttes]

Hi!
The error... It looks like you have at least one task without Due Date assigned, right?

Hope this helps

[tomjedig]

Yeah I have a few. I'm building this for for school to "hide" tasks that were due in the past. So there will be a few tasks due on one date every week.

[efialttes]

Hi again!

On your Condition rule, try to replace 'due date' dynamic content and assign this expression instead:

coalesce(item()?['dueDateTime'],'NoDueDate')

...so in case of no DueDate, it takes value NoDueDate for comparison purposes

If problem persists, try to use this other expression

if(empty(item()?['dueDateTime']),'NoDueDate',item()?['dueDateTime'])

Hope this helps

[tomjedig]

Hi, both expressions don't work, I tried them with both contains and equals.

Do you have another idea for a flow that marks tasks that we due yesterday as completed? I'm using Power Automate only for a few days and maybe this wasn't the easiest way.

[ChristianAbata]

hi @tomjedig I repply your scenario and I do this

1.- I create 2 task in my planner the frist one with current date 26 and another with yesterday start time.

2.- In flow I did this

As you see in first I list all tasks, and then use a condition go get just the task not completed even not started, so if you want to get the started you can use 50 in the compare if value.

3.- Then I add another condition to compare my startDateTime task to my actual date time using this expresion

formatDateTime(utcNow(),'yyyy-MM-dd')

and it works, I get 1 true value for the task that was created for yesterday and a false value for the value today.

Hope this can helps.

[tomjedig]

Hi @ChristianAbata, I re-built this now, btu with the due date instead of the start date, as I want to mark tasks that were due yester or even longer ago as completed.
Everything worked, but it says I've got an error. Would it help to remove the first condition? All my Planenr tasks have the same state (except the ones that are already completed). I still have to decide whether to set new created tasks to "in progress" or "not started".

[ChristianAbata]

shure my friend @tomjedig  please see this gif.

Please consider to mark my answer as solution 😉 a like could be great to.

[tomjedig]

I still got the an action failed error for the first condition 😞
The flow works, the tasks get marked as completed but it shows that it got an error 😕

[ChristianAbata]

please show us the error @tomjedig 

[tomjedig]

Oops, forgot to attach the screenshot.
I've got another idea: what about making the condition like this? If due date is equal to 

getPastTime(24,'Hour','yyyy-MM-ddThh:mm:ss')

[tomjedig]

I tried the idea that I said at the end of my message, it doesn't work.
So we have to fix that error somehow 🤔

[ChristianAbata · Accepted solution]

@tomjedig  this is because in some task you don't have a duedate added so you are trying to compare and empty value with your expression. 

Please look for the task without due date.

[tomjedig]

@ChristianAbata That fixed my error now. Thanks for all the help 🙂