Forum Discussion
How to make due dates in Planner automatically update
Hello,
I have a Planner tab for a project I am managing in Microsoft Teams. The due dates for the project are determined by which bucket each task is in. Is there a way to automate adding in those due dates (sort of like start date + 3, like in Excel), and to tie them to the bucket the task is sitting in?
I'd also like to be able to automatically change the checklist for each task based on the bucket it is in. I assume Flow is the right medium to do this in, but I haven't been able to figure it out.
6 Replies
- Flow wouldn't really work here since we don't have a "When a planner task changes" trigger, we pretty much are limited on what you can and can't automate. Since you'll be dragging tasks to buckets, you won't be able to trigger any action.
Planner is a pretty basic tool, it's grown a bit, but it's still what I consider pretty basic. If they would open up some more triggers like the modified trigger power users + could make some really cool automations like we could with SharePoint task lists back in the day.
You might want to look into using SharePoint lists to do your project tasks lists since you'll have way more control over columns and flow in that scenario and you can even put a PowerApp UI over the top if you want to get real fancy.- You are right we don't have that trigger, but a Flow can also run on a schedule so the Task update in theory is possible if you write the right logic there
jcgonzalezmartin Yuck, I guess you could work something like that :P.
Just off top of my head this might work
The expression for the adddays might be off, but the problem is, you can't really ever tell when something has already been modified so all your tasks will always get updated everytime unless you put in addition condition checks for don't run if duedate is adddays(statedate,3) etc. But this assumes all due dates are always the same. if you change these manually they will get overwrote back to 3 days everytime, so your options here are limited. It might give you some thought process around how you can get started at least.
- The only way I think you could possibly do that is by means of Flow
jcgonzalezmartin That's what I was thinking - do you have an idea of how I could write that flow?
