I have a simple sharepoint list with a user id a deactivation date and a field indicating that the email has been sent. The goal is for sharepoint to send an email warning the user id that their account has been deactivated on said date. This workflow works fine except if the date is modified, the email is sent on the original date. For example user ID XYZ is going to expire on 11/10, but if on 11/9 the date is modified to 11/20, the email is still sent on 11/10. I want sharepoint to recognize the the updated date and supress untill 11/20. Here's what I setup as my workflow:

enter image description here

1 Answer 1


You can create a column and keep it hidden and store the deactivation date in this hidden column. Later when deactivation date is changed you can add a condition to check if the new:deactivation date is not equal to the hidden:deactivation date. If it is not then suppress until the new date is equal to today!

  • Thank you. I'm trying to wrap my head around how that logic would look like in designer. Can you share? Nov 10, 2016 at 13:58
  • @sam It's easier just to recheck (after the pause) whether the deactivation date equals today, and loop if it doesn't. But neither solution would solve the problem of if a de-activation is moved to a prior date rather than to a future date.
    – jpaugh
    Jan 18, 2018 at 22:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.