How to Automatically Send Reminder Emails from Excel Due Dates | Power Automate Tutorial
🔥 Looking for the Complete Setup?
This tutorial covers overdue dates, but you can upgrade to the full system here: • Build an Excel Deadline Reminder System wi...
Learn how to combine BOTH 7-day upcoming reminder logic and automated overdue alerts in one single flow!
In this tutorial you will learn how to send automatic reminder emails based on overdue dates stored in an Excel file in SharePoint using Power Automate. The flow runs every day at 6 AM, checks each row in your Excel table, and sends an email whenever a due date matches today or is already overdue — fully automated with no manual work needed.
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
Compare due dates using the formatDateTime and int expressions
Send automatic reminder emails with dynamic content using Office 365 Outlook
Save and test your flow to confirm everything works correctly
00:00 Introduction
00:30 Create a scheduled cloud flow
00:52 List rows from the Excel table
01:20 Add an Apply to each loop
01:37 Add a condition to check the due date
02:40 Send a reminder email
03:24 Save and Test the flow
04:04 Outro
#powerautomate #powerplatform #microsoft365 #powerautomatetutorial