Adding Manager Notifications to Reminder Emails Sent via Power Automate 

Glad this was helpful!!

@JamesFerguson-gc8je - this example assumes a spreadsheet from a learning management system or other source. But a form to update status would work with Power Apps but not Microsoft Forms, since only Power Apps can update an existing record. I will put this on my "to do" list for videos.

I've added a video that will hopefully help with how to add a form to edit the status: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hGE6LNPOadk.htmlsi=Qx8U6BQC9qUkLI4E

Yes. That makes good sense. I'll put a video on the "to do" list. In the meantime, this video shows the basic concept: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6qdqlcmV5sA.htmlsi=2Z60QD1xYbdhEj6U. Rather than sending the email right away, you want to capture all teams missing the deadline and append it to a variable. Then send the email whenever the manager changes in the loop (e.g., you get to the next manager or end the loop). That in turn means that you will want to sort in the Get Items action by the manager email so that all of a manager's tasks sequential.

Sure , i ll definitely watch this. The challenge i am facing , each manager is leading 3 to 5 teams total 30 teams. First reminders ll go the Level 2 manager for each line in the table( each team represents one line in the table ) . I have done flow up to this step My challenge starts from here >>> If Level 2 manager doesn’t update the task status than it ll escalate to Level 1’s manager. (There are four level 1 managers oversee 10 level one managers and their teams ) I am attempting to send one consolidated email to level 1 manager for only those teams which he/she oversees and they did not update the task status after first reminder to level 2 manager. Many Thanks for all the support n guidance