I have a multi-line text field where the data is delimited by commas. The field can contain from 1-32 items. Example: Chicago, Boston, Seattle. I need to determine the number items in the field (in the example it is 3).
I tried using split with a variable counter: split(variables('Locations'),',')[variables('varIndex')] This split sits in a DoUntil loop that increments varIndex by one. However, when the index count exceeds the number of items, I get an error of 'out of bounds array index'.
How can I get a count of the commas or the items? If I know the count beforehand, I can set the DoUntil to stop before it tries the split and throw the error.
Solved! Go to Solution.