Hi why do I get TONS of email using this SP Designer workflow when I change the trigger from Don't send email to Sent email. I just want only 1 email received not more .
Please find 3 attached picture below !
Thanks in advanced
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
If the workflow runs on change it will evaluate the step every time - NOT only the first time it was set. This means that every time somebody change the item and
Trigger = Send mail it will evaluate true and do what you have inside the if statement.
If you only want to send the mail once, you need to make an extra field to keep track of if you have send the mail or not. Then you add an if statement
If Has send mail = false send mail and set field has send mail = true.
If you want it to send a mail every time the trigger is set (Assuming in the items lifecycle it can go back and forth between sending items or not) you would need a field to keep track of the "old" field value then match against it and only trigger if the old value is different from then new value.
Hope this helps clearing up workflow logic a bit.