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 🙂
Solved! Go to Solution.
@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.
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.
On your Condition rule, try to replace 'due date' dynamic content and assign this expression instead:
...so in case of no DueDate, it takes value NoDueDate for comparison purposes
If problem persists, try to use this other expression
Hope this helps
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.
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
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.
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".
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 😕
Oops, forgot to attach the screenshot.
I've got another idea: what about making the condition like this? If due date is equal to
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.