SharePoint Designer Workflow issues - Multiple emails
Written By: Ved Mishra -- 6/16/2011 --
(1266) comments --
Categories: MOSS 2007, SharePoint Designer 2007, WSS3
< Prev -
- Next >
| Become a paid author
I created a SharePoint Designer Workflow for a list. It has a step where it sends an email if the item is modified. After the workflow is fired on
an item change in the list,
a strange issue started occurring. It started sending several copies of the same email. Over and over.
On further investigation, I found that my server is SharePoint 2007 SP1. And
prior to SharePoint 2007 SP2, a workflow on an item change will create infinite
loop. The exact scenario that was happening is shown in the figure below:
In order to resolve that you could do the following. Please see figure below:
- Upgrade your server to SP2. Now this is easier said that done. Especially in
a large environment this could be a month long task. But you don't need to worry
if your server is already on SP2. How to check that? Anything prior to 126.96.36.19921 is not SP2. You can check the version of your server from your site itself. You don't even
need to access Central Admin. Go to any of your SharePoint Sites --> Site Actions --> Site Settings (short cut URL: yoursite/_layouts/settings.aspx) and you will see the version just
after Site URL and Mobile Site URL.
Create an additional column or a workflow variable to store a FLAG value. Set this FLAG when you reach the end of workflow. Check the FLAG status at first step and then stop
the workflow if FLAG is already set. See the figure below for better understanding
I will explain the steps on how to do it using a flag column. Create a column called "Flag" in the list. Ensure that the default value is set to "No"
< Prev -
- Next >