AnsweredAssumed Answered

Error: Index property is greater than the number of items in the collection.

Question asked by seattle17 on Aug 19, 2016
Latest reply on Sep 14, 2016 by seattle17

Hi there,

I am currently setting up workflows for a roster I need sent to an external client and I've set up one successfully but the second one I've set up (nearly identical to the first) keeps bringing back "Error operating on collection variable. Index property is greater than the number of items in the collection." I understand this usually comes back when a collection does not contain the same number of values as the others but these collection operations are collecting data from the same list as the first workflow I did and mostly the same data with a few additions. None of the values are null. I think there is something I'm not seeing or a syntax I've gotten wrong. I know exactly which Collection Operation is my problem but I cannot figure out how to fix it - Google research has failed me. Here is my workflow currently:

Workflow1.JPG

Workflow2.JPG

Workflow3.JPG

 

Sorry for the crappy disjointed image. Here is the configurations for each action.

SetVariable1.JPG

 

QueryList1.JPGQueryList2.JPGForEach.JPGCollectionOp1.JPG

I won't show you all the collection operations as there is 9 but they're all the same just different data points. Here is the one that is causing the error - #9.

 

CollectionOp9.JPGCalcDate1.JPGCalcDate2.JPGBuildString1-2.jpgBuildString2-2.jpgNotification.JPG

I've tried a lot of variations, particularly with where/how to insert the check in/out dates but nothing works. I've also tried switching the Date Scheduled variable from Date/Time to Single Line of Text type.

Variables1.JPGVariables2.JPG

This is driving me crazy! I don't have the option to Enable Verbose Logging (which I saw in another string) but I've asked IT to turn that feature on. I just can't stare at it anymore. All suggestions are welcome! Thank you.

 

- Suffering in Seattle

Outcomes