Unanswered

Send an Automatic Email based on a Date in Sharepoint List

(0) Share

Report

Posted on by RobertPC77

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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

AlanPs1 2,471 on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@RobertPC77

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.

Was this reply helpful? Yes No
RobertPC77 59 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RobertPC77 59 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
RobertPC77 59 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No