Mar 16 2017 05:59 AM
I have a list with these 2 columns - Manager and Due Date. Does SharePoint provide OOB feature to send email to Manager when Due Date is the current date ?
Thanks for any help...
Mar 16 2017 06:36 AM
Mar 16 2017 07:17 AM
As mentioned by @Chris Gullicksen you need to use SharePoint designer workflow and condtion to wait until the due date and send email. You can also do the same using "Flow".
Mar 16 2017 07:26 AM
As the due date will only need to trigger an email once you could also condifer running PowerShell as a scheduled task. Simply schedule the PowerShell to scan through the list on a daily basis.
Mar 16 2017 10:33 AM
Mar 17 2017 05:32 AM - edited Mar 17 2017 05:33 AM
For on-premises SharePoint, you could use a community project I wrote a while ago as the foundation for what you want to achieve:
Mar 19 2017 06:36 PM
Mar 21 2017 01:00 PM
SolutionHello,
Welcome to SharePoint, glad to hear you are new. To start up lets find out if you have permissions to accomplish this. Do you know if you have Full Control permissions to the site you are working on?
SharePoint workflows can be built if you have the proper permissions and you can use this Development tool that is free to download called SharePoint Designer. http://www.microsoft.com/en-us/download/details.aspx?id=35491 - If you haven't used SharePoint designer I would recomend finding some training informaiton related to it before you begin.
Here is some technical documentation on SharePoint Designer 2013 https://msdn.microsoft.com/en-us/library/office/jj163986.aspx
Anyway here is a sample list I created to do this
List Columns: (type) (noted an asterisk * = required columns)
Open Designer > Open your site > Open your list & Create a new workflow that is associated with it.
workflow Logic:
IF Current Item: Due Date Greater than or equal to Today
Pause until Current Item: Due Date
Email Current Item: Manager
(end)
This is just a basic concept and you can always do more :)
Mar 21 2017 03:01 PM
Any thoughts on leveraging tasks which can provide initial notifications and reminder e-mails? Saves you from writing code.
Mar 24 2017 06:39 AM
Mar 27 2017 11:13 AM
Mar 27 2017 12:09 PM
There shoudln't be any noticable overhead
Jul 19 2017 06:34 AM
Nov 18 2017 04:05 AM
Hi,
Is this for manual start to workflow or when item is added please? I have a list with 2,400 items and I will need every item to behave in the way described. Manual will be a pain!
Dec 08 2017 01:26 PM
Feb 20 2020 11:03 PM
Hi Chris,
I am new to Microsoft flows. Could you please share a screenshot for this flow.
Thank you.
Feb 28 2020 08:38 AM
Hello@sdkhundmir I used a SharePoint Designer workflow for this, not a Flow or PowerAutomate set up for this.
Mar 21 2017 01:00 PM
SolutionHello,
Welcome to SharePoint, glad to hear you are new. To start up lets find out if you have permissions to accomplish this. Do you know if you have Full Control permissions to the site you are working on?
SharePoint workflows can be built if you have the proper permissions and you can use this Development tool that is free to download called SharePoint Designer. http://www.microsoft.com/en-us/download/details.aspx?id=35491 - If you haven't used SharePoint designer I would recomend finding some training informaiton related to it before you begin.
Here is some technical documentation on SharePoint Designer 2013 https://msdn.microsoft.com/en-us/library/office/jj163986.aspx
Anyway here is a sample list I created to do this
List Columns: (type) (noted an asterisk * = required columns)
Open Designer > Open your site > Open your list & Create a new workflow that is associated with it.
workflow Logic:
IF Current Item: Due Date Greater than or equal to Today
Pause until Current Item: Due Date
Email Current Item: Manager
(end)
This is just a basic concept and you can always do more :)