+10
Hi
I'm trying to get an email alert to show the following fields:
So I've created a For Each Loop:
with twelve collection actions within to start to build up the fields. When I tested it (before I went any further) the workflow errored at For Each with:
'Error operating on collection variable. Index property is greater than the number of items in the collection' a snapshot of the collection actions is below, what am I doing wrong?
how do you populate single collection variables?
do they all have just the same number of elements?
+10
Earlier in the Workflow I have a Query list action which queries 17 fields, so is the problem that the number of fields in
the Query action doesn't match up with the Collection operations?
so is the problem that the number of fields in the Query action doesn't match up with the Collection operations?
no.
your query seems to be correct, I was afraid you popolate each collection variable with a separate query so you end up with different number of elements in each of them.
can you post configuration of 1 or 2 collection operations how do you read values from collections?
+10
No problem, here's a few of them:
this seems to be correct as well.
do you perform any other operation on any of collection variables between query list action and for each loop?
especially if it is an action that might change its content.
can you proof-check that you haven't accidentally configured different collection variables in query list action and respective collection operation?
or perhaps index variable?
or collection operation function?
if everything is configured correctly, then I would probably tried to disable all the collection operation actions within the loop and run workflow whether it passes through or not.
then I would tried to enable collection operation actions one by one and tested which works and which one fails.
+10
I tried what you suggested and disabled each Collection operation, then enabled them one by one and ran the workflow. It worked fine until I got to the 9nth Collection operation pictured below:
The text_cost_centre variable is a Single line of text variable, it stores a series of numbers and letters. The error t's throwing up is the same as before 'Error operating on collection variable. Index property is greater than the number of items in the collection.'..
I disabled this Collection operation and went onto the next but got the same error.
+10
The Cost Centre Field in the list is a Drop Down Field. I changed the variable that the result is stored in to a Choice variable but still got the same error.
+10
Try disabling the 8th Collection operation and see if the 9th works.
+10
Yes tried that and it errors. I'll post the full Loop workflow,
+10
+10
I think I've got to the crux of the problem. It's the Cost Centre list. It's a separate list that is being populated via a Data source in the properties. I've used the lit again on another form and got the same problem. Question is how do I get round it, or do I just recreate the list?
+10
Might it have something to do with the amount of items in the Cost Centre list there are approx. over 50?
+10
Nope... 50 should be easily handled.
+10
Is the Cost Center value being populated into a field in the list or a only to a control on the form?
Test the variable (verbose logging) to see if the cost center is making it into the variable.
It worked fine until I got to the 9nth Collection operation
ok, step forward we have guilty one 
The Cost Centre Field in the list is a Drop Down Field.
is it a dropdown for lookup or choice field?
It's the Cost Centre list. It's a separate list that is being populated via a Data source in the properties.
can you explain/document what you mean with this?
by the screenshot you recently posted for 9th collection operation, you reference there 'col-costcentre' collection.
however, query list operation seems to store 'Cost Centre' into 'col_cost_centre' collection.
so, these seem not to match!
have you checked the configuration as I advised above? likely you experience the same misconfiguration for 10th collection operation...
+10
great!
have you got it working? if so please mark correct answer.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
