Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

Creating a flow for Late or Upcoming planner tasks sent Department wide

I would love to create a Flow in which each week Monday at 9AM an e-mail is sent to everyone in my department reporting upcoming and late planner tasks. I found one that emails me personally my late Planner tasks but I would like to have one email that sends our Teams planner tasks and who they are assigned to whether its upcoming(within a week) or late to our entire department. Is this possible? 

Level: Powered On

Re: Creating a flow for Late or Upcoming planner tasks sent Department wide

Hi @theeCoDi,


Perhaps you can take inspiration from the following Flow template: "Create a daily summary of Planner Tasks by Bucket"


The idea is that for a configured frequency, the flow will list the tasks of a specific plan.
Then for each task, you can check some caracteristics before adding information to a variable containing html that will be used at the end of the flow to construct the body of the email you want to send.
As the variable you construct during the flow contains html, you can structure the tasks details as you want.


I hope that this will help you.


Raphael Pothin

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,842)