Dear SharePoint experts,
We would like to ask for tech support on how to create Email alert when due date is approaching using SharePoint Workflow.
SharePoint 2013.
We have a list with this fields:
– Name of users
– Email
– Setup Date
– Password Expire
What we want to happen is to set an alert, Email alert to the user(s) 5 days before their password expiration arrives.
We’ve created other workflows with Email alert already, but that workflow is sending email to ALL and not to single user only.
But with this workflow, we want one or several users to receive an email separately, 5 days before their password expires.
Thank you and hope to hear soon…
First you need to create a calculated column which will subtract today’s date from the Password expire date. You can do this with DATEDIF[ExpDate], TODAY(),”d”, this will give an outcome in days (“d”)
Set the IF function as such that when this calculation is <5, “Yes” will be filled into the column.
This “Yes” will be the condition to fire up the workflow.
Will you manage with this column?
