Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

4
Developing a workflow that loops through a subgroup of items in a list. It seems to work up until the 10th item (every single time) and randomly stops
Post Body

TOO MUCH BACKGROUND: I'm currently working with a sharepoint list that is an archive of requests for several different offices. These requests, while submitted individually, need to be approved en masse and so I was trying to develop a workflow that would trigger when the approval is processed on one and then incrementally cause all related requests to get approved as well.

To do this, I created a column that essentially is a boolean to keep track of which ones have been completed and which haven't been addressed yet. If it has yet to be visited the item associated with the request will have a value of CODE0 where "CODE" is a unique identifier for each office.

I also make sure that when the approval action is taken from the infopath form that the number of items that need to be approved is recorded in a separate column (UpdatedRequests). The infopath form also initializes a column that serves as the index (WFIndex) for a for loop and sets it to zero.

The workflow starts by updating the necessary fields within the specified request item (specifically CODE0 is updated to CODE1) then it sets a workflow variable equal to WFIndex 1. If WFIndex 1 is less than UpdatedRequests then it means there are still items in the list that have the column entry of CODE0 (If it didn't it would terminate the workflow and the loop ends as well). It then updates an item on the list where the column is set to CODE0 (since if it isn't a unique identifier sharepoint will return the first item it finds) and repeats the process.

As I mentioned earlier, it seems to work up until that 10th item. It still will update the 11th item, but it will fail to trigger the workflow on it (even though a change has occurred for the item and the workflow is set to run either when an item is changed or created). And if I just manually start the workflow from the item it ended on it will continue and do another 10 before stopping again.

TL;DR Is there a limit on the number of successive workflows that can occur following an initial trigger event? I'm hoping this is the case as there is a maximum number of requests that an office can request, and I'm hoping I can just ask our sharepoint admins if it would be possible to increase that limit.

Author
Account Strength
100%
Account Age
16 years
Verified Email
Yes
Verified Flair
No
Total Karma
7,072
Link Karma
3,860
Comment Karma
3,212
Profile updated: 3 days ago
Posts updated: 7 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
7 years ago