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…
Yes, after this you can create your workflow. Do you use SharePoint Designer?
And please, if I don’t reply as quickly as you would like, remember that I’ve got paying costumers to attend as well 😉
Any help regarding the wf Ms. Carmen? 🙂
Thank you!
Did already, then after that, what would be the next step? Emailing the user using WorkFlow right?
You need to create 2 columns, your choice how to name them 😉
Column1, calculated column with the following formula:
=DATEDIF[Password Expires], TODAY(),”d”)
outcome as “single line of text”
Column2, calculated column with the following formula:
=IF[Column1]<5, “Yes”, “No”)
outcome as “single line of text”
The column2 holds the value to fire up your workflow to send an email. I work with SharePoint Designer, and it is quite easy to add an action “Email user” and you can set up the complete email to your liking, including fields that point to columns in your list.
Good luck!
Kindly check the attached image for the screenshot of the table that I created…
And please let me know where to change, add, or what to do next…
Thank you!
I tried this, but the value on the C2 where it should come Yes, it is #NUM!
I really need to add a reminder workflow where the workflow automatically generates a reminder email when the deadline date is due in 2 weeks.
I appreciate if anyone can help.