Announcements
Hi guys
I’m looking to set up a flow that will send an email to a person 5 days before their start date, then their password on their start date.
All of the info will be stored in Excel, is there an easy way of having this on a flow so it will only send for the following weeks New Starters?
for example, emailing people who are going to start on the 5th Feb tomorrow. Then emailing people who start on the 12Feb on the 7th Feb? All contained within a single sheet.
thanks
Hi @BobbyyMannn Yes this is possible! I sketch out the solution (a Power Automate Cloud flow) roughly for u:
Hope this helps!
You might find my tutorial helpful: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
Although this tutorial covers how to create this flow using a SharePoint list—the concept is the same when using data from an Excel table. Instead of a Get Items action, use the List Rows present in a table action. When working with dates and times in Excel ensure you are selecting ISO 8601 as the DateTime format.
Stop forgetting important dates 📆! In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.
This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:
📅 Student Birthdays
📅 Project Due Dates
📅 Contract/Membership Renewals
📅 License Expirations
📅 Client Anniversaries
---
IN THIS VIDEO:
✅ How to Send an Email based on a Date Column in SharePoint
✅ Using the Recurrence Trigger in Power Automate
✅How to Use the Filter Array Action with multiple conditions
✅ How to Get Dynamic Content from a Filter Array Action
✅How to Get a Date Three Days from Today
✅ How to Create a Dynamic Date Based on utcNow()
✅ How to Return a Count of Items
✅ How to initialize and set a variable
✅ How to use the Send an Email (V2) action
✅ How to send test emails
Hope this helps!
| If I helped you solve your problem—please mark my post as a solution ✅. Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion |
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
