I have a merged column in SharePoint. I am using Nintex workflow to split the items in the merged column and store them in a collection variable. I am trying to use a collection operation to Get each item in the collection variable and store each item in a text variable using a For Each loop.
What happens is that the very first iteration of the For Each loop stores the entirety of the collection variable in the text variable. The delimiter is <br>. The split works correctly. I am using a number variable as the Index.
What's supposed to happen is that the For Each loop will create a list item in another list for each of the items in the collection variable. It seems as if the Split collection operation isn't working.
Any idea why this could be happening?
I found the solution here:
Apparently <br> is not a workable delimiter. I created a new field on my InfoPath form to merge the repeating table data using a semicolon delimiter, configured the collection operation in the Nintex workflow accordingly, and voila, it works!