Send New-Hire Email Reminders from Excel with Power Automate
Question details
The user wants to automatically send email reminders for a new-hire onboarding process based on a start date stored in an online Excel workbook.

- Product
- Microsoft Excel and Power Automate
- Device & OS
- not provided
- Scenario
- Managing new-hire onboarding dates and automating reminder emails to ensure tasks are completed on time.
- Observed behavior
- A scheduled flow is needed to read the start date from Excel, calculate the reminder date (e.g., two weeks before), and trigger an email when that date arrives.
Ensure your Excel workbook is stored in an online location such as OneDrive or SharePoint, and your onboarding data is formatted as an Excel Table with clear columns for 'Start Date' and 'Email Address'.
Create a Scheduled Flow in Power Automate
Build an automated workflow that runs on a schedule to check the Excel table and send emails if the target reminder date is met.
Power Automate can periodically check your online Excel tables. By setting up a scheduled flow, it can evaluate each row's start date and dispatch an email precisely when the reminder period hits.
Log into Power Automate, select 'Create' from the left menu, and choose 'Scheduled cloud flow'. Name your flow and set it to run once every day.
Add a new step and search for the 'Excel Online (Business)' connector. Select the 'List rows present in a table' action, then locate your onboarding workbook and select the specific Table containing the new-hire data.
Add an 'Apply to each' control to loop through the Excel rows. Inside the loop, use a 'Condition' block to check if the current date matches the calculated reminder date (e.g., using an expression to subtract 14 days from the Start Date).
In the 'If yes' branch of your condition, add the 'Send an email (V2)' action via the Office 365 Outlook connector. Use dynamic content to populate the 'To' field with the email address from your Excel table, and draft the reminder message.
Manage Your HR Spreadsheets with WPS Office
While Power Automate workflows require the Microsoft ecosystem, WPS Office provides a lightweight, highly compatible alternative for creating and managing all your HR, onboarding, and scheduling spreadsheets.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Spreadsheets: Open your existing .xlsx onboarding files directly in WPS Spreadsheet without losing formatting.
- 3. Update and Format Tables: Easily update employee start dates, format your data as tables, and save them for use in your administrative processes.

Frequently Asked Questions
Can I trigger a Power Automate flow from a local Excel file stored on my desktop?
No, Power Automate requires the Excel workbook to be stored in a cloud location like OneDrive for Business or SharePoint so the service can access and read the table data continuously.
Why is Power Automate not recognizing the data in my Excel worksheet?
Ensure that your data range in Excel is explicitly formatted as a Table (select your data and click Insert > Table). Power Automate's 'List rows present in a table' action cannot read data from a standard worksheet range.
How do I calculate the date exactly 14 days before the start date in Power Automate?
You can use an expression in your flow's condition or compose action, such as `addDays(items('Apply_to_each')?['StartDate'], -14)`, which subtracts 14 days from the Start Date column to determine the exact email reminder date.




