Creating a List workflow for a Certification list for employees, so management will be able to track ending certifications.
Employees will enter their certifications in a form (each cert, date of cert obtained, and their expiration).
Leadership wants each cert (could be as many as 6 per person) to have a separate email notification fire off at different time intervals prior to the expiration date as a "red flag" to get their cert updated. (180 days, 150 days, 120, 90, 60, 45, 30, 21, 14, 7) until the user changes the expiration date (essentially updating his record).
Currently, I have a parallel action set up for each reminder:
Action Set
Calc Date (Calc "Expiration Date" -column- minus 6 months, store in variable "6monthreminder")
Pause Until (6monthreminder)
Send notification
When I tested this current set up - Ex. a cert ending in 45 days, they got ALL notifications 180 down to 45 days (6 different email notifications) versus the one that was most relevant.
What am I missing?
