I'm trying to set up a Flow which identifies incomplete tasks in Planner, then sends an email notification to the person the task is assigned to 1 week ahead of it being due. It is intended to remind us that key project milestones are approaching.
Below is what I have so far. I have no idea whether or not it's right, and I can't work out how to express 'week from due date'.
I'd be really grateful for any help on this. Then I just have to workout how to integrate it with Teams...
First thing first is that your flow will only trigger when a task is assigned to whomever set-up the connection between flow and planner. You're better off having a recurring trigger like every day or week and pulling in a list of tasks.Then you'll need to loop over each task to check it's due date and progress. Your progress and due date checks are in the right places but this is how to check if a task deadline is a week ahead:
(This assumes that you're already inside of a loop, looping over tasks)
@less(items('YOUR LOOP NAME')?['dueDateTime'], addDays(utcNow(),7))
I haven't tested this but it should work. You will also want to make sure that the due date isn't null before trying to use it as planner allows it to be. If you don't check your flow could fail. This is what we're currently using:
Once you've filtered to tasks that are due within 7 days you can then extract the data for that task for processing. To extract assignments see my posts here:
I hope that helps!
Thanks for this! I'm actually much more of a beginner - I'm not sure how to up a 'recurring trigger'. let alone 'extract assingments'. I may have to abandon this idea - I really wish Teams had something simple like alerts within Planner that we could use instead!
You're very welcome @LydiaH.
Recurring trigger is located under trigger, schedule like this:
Then to set it up to run every day at 15:00 you'd do this:
The link I posted in my answer will give you a pretty good idea how to get the user information who has a the specific task assigned to them. The more you play around with Flow and make mistakes the more you'll be comfortable with it and if you have any questions just ask them here and the community will be glad to help. If you want more in-depth support on how to achieve what you want go ahead and drop me a personal message and I'll give you a hand.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.