How to Send a One-Time Outlook Notification for a SharePoint List Date
Question details
The user needs to trigger a one-time Outlook email notification to a manager when a date in a SharePoint list column (e.g., Joining Date) matches the current date.
- Product
- Microsoft SharePoint & Power Automate
- Device & OS
- not provided
- Scenario
- Managing employee joining dates in a SharePoint list and needing to automate manager notifications exactly on the joining date without sending duplicate emails.
- Observed behavior
- Native SharePoint list rules are insufficient for sending a strictly one-time date-based notification; an automated flow with a tracking column is required to achieve the goal state.
Ensure you have active licenses and appropriate permissions for Microsoft SharePoint, Power Automate, and Outlook. You will also need to add a 'Status' column (e.g., Yes/No) to your SharePoint list to track whether the notification has already been sent.
Create a Scheduled Power Automate Flow
Use Microsoft Power Automate to build a scheduled flow that runs daily, compares dates, sends the email, and updates a status column to prevent duplicate notifications.
Since native SharePoint rules trigger based on item creation or modification rather than a specific date arriving, Power Automate is the most reliable way to handle time-based triggers. A daily scheduled flow will iterate through your list and find any matching dates.
To ensure the email is only sent once per employee, the flow must update a tracking column after sending the email. Future runs will then skip items that have already been processed.
Open your SharePoint list. Click 'Add column', select 'Yes/No', name it 'NotificationSent', and set the default value to 'No'.
Log in to Power Automate, click 'Create' in the left menu, and select 'Scheduled cloud flow'. Name your flow and configure it to repeat every 1 day.
Add a new step and search for the 'Get items' action under SharePoint. Select your Site Address and List Name from the dropdown menus.
Add an 'Apply to each' action and use the 'value' output from 'Get items'. Inside the loop, add a 'Condition' to check if your 'JoiningDate' column is equal to today's date (using the expression formatDateTime(utcNow(), 'yyyy-MM-dd')) AND 'NotificationSent' is equal to 'No'.
In the 'If yes' branch, add the 'Send an email (V2)' action to compose your Outlook message to the manager. Finally, add the 'Update item' SharePoint action to change the 'NotificationSent' field to 'Yes' so it won't trigger again.
Discover WPS Office for Your Daily Document Needs
While Power Automate and SharePoint are great for complex backend automations, WPS Office provides a free, lightweight, and complete office suite for your daily document processing, spreadsheets, and presentations with seamless Microsoft format compatibility.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up the lightweight office suite in minutes.
- 3. Open and Edit Microsoft Files: Launch WPS Office and directly open your existing .docx, .xlsx, or .pptx files to start working with full compatibility.
Frequently Asked Questions
Can I use basic SharePoint list rules instead of Power Automate for this?
Basic SharePoint list rules are generally triggered by an action such as item creation or modification, not by a specific date naturally arriving. For date-based triggers that require daily checking, Power Automate is the required solution.
How do I prevent Power Automate from sending duplicate emails every day?
The best way to prevent duplicates is to add a Yes/No status column (e.g., 'EmailSent') to your SharePoint list. After your flow sends the email, use the 'Update item' action to set this column to 'Yes'. Your flow's condition should always check that this column is 'No' before sending an email.
What expression should I use to get today's date in Power Automate?
You can use the utcNow() expression to get the current date and time. To safely compare it with a SharePoint date-only column, use the formatDateTime function, such as formatDateTime(utcNow(), 'yyyy-MM-dd').
Can I route the Outlook notifications to different managers based on the employee?
Yes. If your SharePoint list includes a 'Manager' column mapped to a Person or Group, you can use dynamic content in the 'Send an email' action's 'To' field to route the notification dynamically to the specific manager assigned to that list item.
