Build an Excel Deadline Reminder System with Power Automate
In this tutorial you will learn how to automatically send a reminder email when a deadline date in your Excel file is coming up within the next 7 days, and a separate email when that deadline has already passed, using Power Automate. The flow runs every day, checks each row in your Excel table, and sends the right email to the right person at the right time — so no one misses an upcoming task and everyone knows when one is overdue.
By the end of this video you will know how to -
Set up a scheduled recurrence trigger in Power Automate
Use the List rows present in a table action to read Excel data from SharePoint
Loop through all Excel rows using Apply to each
Build a condition with two date checks to detect upcoming deadlines
Send automatic reminder emails to the right recipient using Office 365 Outlook
Add a second condition to detect overdue deadlines and send an overdue email
Save and test your flow to confirm everything works correctly
Expressions used in this flow -
Deadline date conversion (used in both conditions left side and both email bodies):
formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['Deadline date'])), 'yyyy-MM-dd')
Today (upcoming condition, row 1, right side in both conditions): formatDateTime(utcNow(), 'yyyy-MM-dd')
Today + 7 days (first condition, row 2, right side): formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')
Today (overdue condition, right side of rest in both conditions):
formatDateTime(utcNow(), 'yyyy-MM-dd')
00:00 Introduction
00:21 Step 1: Create a scheduled cloud flow
00:42 Step 2: List rows from the Excel table
01:08 Step 3: Add an Apply to each loop
01:25 Step 4: Add a condition for upcoming deadlines
02:34 Step 5: Send a reminder email for upcoming deadlines
03:30 Step 6: Add a condition for overdue deadlines
04:00 Step 7: Send an overdue reminder email
04:29 Step 8: Save and Test the flow
05:18 Outro
#powerautomate #excelreminders #powerplatform #microsoft365 #overduetasks #powerautomatetutorial