Outlook reminder email flow with escalation and Outlook task assignment

[flyingspoon]

Hi everyone,

I am gathering resources on creating a flow that:

1. Sends weekly reminder emails from Outlook to email address(s). 

• Ideally, the first email sent should also automatically add a task to one of the email recipients task lists in Outlook.

2. After the 4th week, if the individual hasn't finished their work, escalate the reminder by adding one additional individual to the email. 

3. Same thing as above. If after 8 weeks of weekly reminders, add on another person to the email.

4. Same thing as above. If after 12 weeks of weekly reminders, add one final individual to the email. 

In the reminder emails, is there a way to add a feature that would allow the recipient responsible for producing the work to indicate they have completed their work? Perhaps a checkbox or something else that when utilized would halt the reminder emails and stop the escalations?

Does anyone have experience building a flow like this, or something similar to it? Do you have any resource recommendations, suggestions, or tips that you could share?

Thank you!

[mohsinkhalid · Accepted solution]

There could be several ways to solve this, something that comes to mind on this for an out of the box solution would be the approval process. You could use it to ask the user if they are done with the task and they would be able to click on done right within the email and you can stop the flow then, see more details here

https://docs.microsoft.com/en-us/power-automate/modern-approvals