How to Automatically Send Deadline Reminders for Upcoming Due Dates in Excel with Power Automate
🔥 Want to add Overdue Alerts too?
This tutorial covers upcoming 7-day reminders, but you can get the full system here: • Build an Excel Deadline Reminder System wi...
Learn how to combine BOTH 7-day advance logic and automated overdue alerts in one single flow!
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 using Power Automate. The flow runs every day, checks each row in your Excel table, and sends an email whenever a deadline is approaching — so you never miss an upcoming task again.
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 with dynamic content using Office 365 Outlook
Save and test your flow to confirm everything works correctly
Expressions used in this flow -
Deadline date conversion (used in both condition rows and in the email body):
formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['Deadline date'])), 'yyyy-MM-dd')
Today (condition row 1, right side):
formatDateTime(utcNow(), 'yyyy-MM-dd')
Today + 7 days (condition row 2, right side):
formatDateTime(addDays(utcNow(), 7), 'yyyy-MM-dd')
00:00 Introduction
00:20 Create a scheduled cloud flow
00:42 List rows from the Excel table
01:09 Add an Apply to each loop
01:26 Add a condition to check upcoming deadline dates
02:34 Send a reminder email
03:25 Save and Test the flow
04:08 Outro
#powerautomate #excelreminders #powerplatform #microsoft365 #deadlinereminder #powerautomatetutorial