Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Send an Automatic Email based on a Date in Sharepoint List

I have a list in Sharepoint that includes a different date for each entry.  I would like to have a reminder email sent to an individual in my organization based on that date.  


Suggestions?  Thank you in advance!

Resident Rockstar
Resident Rockstar

Hi @RobertPC77 , thank you for your post, it is entirly possible to do this.

Please can you post some pictures of your Flow so we can see how far you have gotten and we can advise where to go with it?


Also, a great place to start with triggering emails from a SharePoint List based on a date in this template - Send a Happy Birthday email to employees on their birthday


You may want to populate some data in a list and get this working and when doing so, you will have solved your problem, if not completely, almost 100%.


If you have found my post helpful, please mark thumbs up.


Any other questions, just ask.


Thanks, Alan

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Super User
Super User


The quickest way to meet your requirement is to use the "out of the box" Flow "Set a reminder" feature.  Most SharePoint lists and libraries to which you have added a date column will have an option available under the Flow menu titled "Set a reminder".  This option will create a Flow that will send out reminder emails to the person who created the Flow a specified number of days before the date you select.  So, the best way to use this feature is to instruct the user who wants to receive the emails to click through and create the Flow.  If you do it for them, you'll need to edit the Flow so that it sends emails to them instead of you.


If the "out of the box" Flow does not meet your needs, here is a link to a blog post that I wrote that details how you can create your own reminder Flow.




If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Thanks to all for the quick responses!  I do have one issue that I can't seem to work around...even though I am using Sharepoint in Office 365, my email is not in Outlook 365.  Unfortunately, I am not able to send the email because I am not in Outlook 365...I hear we are getting it soon.

Hello Guys!


Thank you for your suggestions, however I have not come up with a solution.


I work in a School District where we occasionally have to disable student accounts for a certain amount of time.  I have a MS Form set up that gets automatically uploaded into a Sharepoint list when Submitted.  In the list is a column to ENABLE the Student's Account.  I have a notification being sent to the Network Administrator to DISABLE the Student's Account.  However, I have not yet figured out how to create a notification to be sent to ENABLE the Student's Account.  I was hoping that I could trigger a notification based on the ENABLE date in the SP list.


The Reminder in SP only notifies me as the owner.  I have look in your recommended solutions, but have not quite figured it out. 


One other issue...our School District uses Office 365, but have not yet moved to Outlook 365...we're still on Outlook 2016.


I appreciate any guidance you can share! Thank you!

Here's what I have so far (kind of based off of the ODFilter mention in the earlier response...




Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,670)