How to Send Automatic Email Reminders from Microsoft Lists
Question details
The user needs to configure Microsoft Lists to automatically send email reminders based on specific dispatch dates, rather than relying on manual list modifications to trigger notifications.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Managing dispatch dates, due dates, or deadlines in Microsoft Lists where team members or stakeholders require automated email notifications on the exact day.
- Observed behavior
- Standard list automation rules only trigger when a date column or list item is manually edited, failing to send reminders automatically when the target date simply arrives.
Ensure you have access to Power Automate through your Microsoft 365 account and that your Microsoft List contains a properly formatted 'Date' column to serve as the reminder trigger.
Create a Scheduled Power Automate Flow
Set up a daily scheduled flow in Power Automate that automatically checks your list items and sends emails when the dispatch date matches the current date.
Unlike standard list rules that require a user to manually edit an item to trigger an action, a scheduled cloud flow runs automatically at a set time interval (such as every day). Scheduled flows execute on the server independently, meaning they will run even if you are not currently signed into Microsoft 365.
Sign in to Power Automate, navigate to 'Create' on the left sidebar, and select 'Scheduled cloud flow'. Name your flow, set the starting date and time, and configure it to repeat every 1 day.
Click 'New step' and search for the SharePoint 'Get items' action. Select your Site Address and List Name from the dropdown menus.
To ensure you only process items due today, click 'Show advanced options' in the 'Get items' action and enter an OData Filter Query. Alternatively, you can add a 'Condition' step inside an 'Apply to each' loop to check if the item's dispatch date equals the current date (using the utcNow() expression).
Inside the condition's 'If yes' branch, add the 'Send an email (V2)' action. Fill in the recipient's address, and use dynamic content from your Microsoft List to customize the email subject and body with relevant details.
Click 'Save' in the upper right corner. Use the 'Test' button to manually run the flow, ensuring that the email reminder is successfully delivered to the required recipient.

Manage Data and Tracking Seamlessly with WPS Office
While Power Automate handles complex cloud triggers for Microsoft Lists, WPS Office provides a lightweight, fast, and free alternative for everyday data tracking and deadline management. You can easily maintain your schedules, track dates, and set up conditional formatting to highlight approaching deadlines using WPS Spreadsheet.
- 1. Download and install: Download WPS Office for free from the official website and install it on your device.
- 2. Open your data list: Launch WPS Spreadsheet and either create a new tracking sheet or open an exported Excel file from your existing lists.
- 3. Apply conditional formatting: Select your date column, go to the 'Home' tab, and use 'Conditional Formatting' to automatically highlight dates that are approaching or past due.

Frequently Asked Questions
Why doesn't the standard Microsoft Lists rule send an email on the exact date?
Standard automation rules in Microsoft Lists are event-driven, meaning they only trigger when an item is newly created or manually modified. If a date arrives but the list item remains unedited, the trigger will not activate. Scheduled flows in Power Automate are required for time-based triggers.
Do I need to leave my computer on for the scheduled Power Automate flow to run?
No. Scheduled cloud flows run on Microsoft's servers in the background. As long as the flow is turned on and properly configured, it will execute at the specified interval regardless of whether your computer is powered on or if you are signed in.
Can I configure the flow to send reminders multiple days before the dispatch date?
Yes. Within your Power Automate flow, you can use expressions (such as addDays) to calculate a future date (e.g., 3 days from today) and compare it against the dispatch date in your list to send advance reminders.
Will this flow accidentally send emails for past dispatch dates?
Not if configured properly. By setting your OData Filter Query or condition to strictly check for items where the dispatch date exactly matches today's date, the flow will safely ignore any items with past or future dates.




