I have a question about splitting items in a for each. For the process I’m developing, I am taking a column from a spreadsheet using a read column activity. I am then using a for each activity for the data taken from the spreadsheet. I am attempting to split the item at a special key (~), so I have two substrings I can set as separate variables. For example,
I tried to use .Split but this has a validation error. Screenshot below.
Does anyone have any solutions or ideas?
Thanks in advance!