So while designing my workflow i stumbled upon a problem where in when ever the status as on date changes to completed it should send a mail to the user. But when i try to edit a a list item which already has Field value as completed and when i save the field it sends a mail to the user again. so i just only want to send the mail when the status has been changed once to completed. Not again and again.

This is my workflow where i am defining a condition as to not send the email when emailsent field has been set to yes ! could you point the problem out please ?

enter image description here

  • Im not sure about Workflows but usually in the SharePoint API you always have to call an "Update List Item" after changing something on the Item
    – efkah
    Feb 12, 2018 at 7:20

1 Answer 1


Is the EmailSent a boolean field?

Also you could try to change it to this:

If EmailSent not equals Yes then send mail + set EmailSent to Yes

There really no need to update EmailSent every time the workflow fires and Status as on Date = completed

  • yes EmailSent is a Boolean Field. i would try this and get back to you soon ! why do you say so? Feb 12, 2018 at 7:19
  • Right now every time the workflow fires it wil chech if the field 'Status as on Date' = Completed and every time it finds that to be true it will set the field 'EmailSent' to True - even if that is already set. This will in turn create a new version of the element (provided you have enabled versioning) - also it will introduce another moving part which you don't really need anyway.
    – Morten K
    Feb 12, 2018 at 7:25
  • it is working perfectly but email sent is not being assigned to yes after the workflow is completed Feb 12, 2018 at 7:27
  • Uhm then I guess it's not working as expected as that would mean the email is sent on every change in the item. Can you please try to share a screendump of how the workflow is configured now :)
    – Morten K
    Feb 12, 2018 at 7:31
  • it is working smoothly now. i am sorry i did not check it properly. Thank you so much for the help! Feb 12, 2018 at 8:59

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.