How to Send a Weekly Deadline Summary Email with Power Automate
🧮 Copy the expressions used in this tutorial
Filter Array:
and(
greaterOrEquals(
addDays('1899-12-30', int(item()?['Due date'])),
startOfDay(utcNow())), lessOrEquals(
addDays('1899-12-30', int(item()?['Due date'])),
addDays(startOfDay(utcNow()), 7)))
Due Date (Create HTML Table):
formatDateTime(
addDays('1899-12-30', int(item()?['Due date'])),'yyyy-MM-dd')
Important:
Replace Due date with your own Excel column name.
Change 7 to any number of days you want to look ahead.
Stop manually checking Excel every week for upcoming deadlines. In this Power Automate tutorial, you'll build a scheduled flow that automatically scans an Excel table stored in SharePoint every Monday, filters items due within the next 7 days, converts Excel serial dates into readable dates, creates an HTML table, and sends a professional summary email straight to your inbox.
Whether you're tracking projects, maintenance tasks, audits, or any other deadlines, this workflow helps you stay organized without any manual work.
✅ In this tutorial you'll learn how to:
Create a Scheduled Cloud Flow
Connect Power Automate to an Excel table in SharePoint
List rows from an Excel table
Filter upcoming deadlines with Filter Array
Convert Excel serial dates into readable dates
Build a custom HTML table
Send a weekly summary email automatically
00:00 Introduction
00:19 Step 1: Create Scheduled Cloud Flow
00:33 Step 2: List rows present in a table
00:55 Step 3: Filter upcoming deadlines
01:45 Step 4: Create HTML Table
02:35 Step 5: Send summary email
02:55 Step 6: Test the flow
03:25 Outro
👍 If this tutorial helped you, please leave a Like, Subscribe, and let me know in the comments what Power Automate tutorial you'd like to see next.
#PowerAutomate #PowerAutomateTutorial #SharePoint #Excel #Microsoft365 #PowerPlatform #Automation #Workflow #BusinessAutomation