I have this scenario where I need to loop through a list of items. As workflows don't offer a looping functionality, I created a following workflow:
1. It fires when an item is changed.
2. It does its job, changes Processed field value on current item from False to True.
3. It looks for an item in the same list that has Processed = False.
4. It changes the found item, so that the same workflow is triggered for the next item and the story starts again.
Everything works fine, except that the 11th element in this chain gets updated by the workflow of 10th element but this update for some reason does not fire a workflow for the 11th element. In history I see it was changed, but in workflow history no workflow was fired. And it happens regularly every 10 items.
I thought that maybe there is a limit for workflows of the same type to be running at the same time - but actually they are not running in the same time - the workflow for the next item is triggered in the end of the current item's workflow.
What may be a possible cause of this kind of issue?