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…
Got it already! Thank you for your kind support…
I’ve created a similar workflow for reminder for meeting-actions. You need to create 2 columns: “EmailReminderCount” (number) and “FirstEmailSent” (yes/no column with default no)
You will need to build 2 workflows: one that will change the column FirstEmailSent to yes, and set EmailReminderCount to 1, and will sent the email to the person in your Name-column. From that point on, depending on the status of the item, the workflow will count +1 in the column EmailReminderCount. This will create a change in the item, therefor starting the 2nd workflow.
The 2nd workflow is to fire up the first one again, this one will just add +1 in the EmailReminderCount column. Also creating a change, and therefor starting the first workflow again so that emails will be sent again and again and again 😉 (if wanted)
Hope this will help a bit
Sorry for the late reply… Kinda busy with some task, but checking the advise that you suggested…
Will test and get back to you soon after I test it…
Thank you!
I mentioned Retention early on. Â I think you would have had this done a week ago if you had gone the retention route. Â just sayin.
The formula in column1 should refer to the column you already have “Password Expire”
This is the last peace of help I’m giving you, it is taking too much of my (unpaid) time. I recommend you get yourself a SharePoint admin course of some kind.
hey is this working,even i need the same kind of solution,but everywhere it says TODAY() is not automatically calculated by column/SP as it changes when the list item is updated/created only.So please let me know if it is working or not?