Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Splitting a Variable with Multiple Rows of Data and Populating SharePoint List Columns

I have found several posts, blogs, and videos that show me how to separate data when there is only one row of data, but I have multiple rows of data that I need to separate. My app populates a plain text multi-line text column in a SharePoint list with the data that was inputted in a repeating table:

Master List item ID; Repeating Table ID; User Name; User Email; User License Type

Because it's a repeating table, there will be more than one entry. My data comes over looking like this:

368;1;Bob Smith;;Team;|368;2;Sue Jones;;Expert;|

I was able to successfully build a flow that would take one row of data (368;1;Bob Smith;;Team;) and populate my columns, but I can't seem to figure out the array and expression for multiple rows. I get the following error:

InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2837': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see for usage details.'

The flow needs to loop at the "|", create a new row in my list, and populate the columns. I feel like I'm close, but I'm obviously missing something. I found a couple of blogs that confuse me. I've tried some different expressions in my first Compose action, but neither work:


My flow looks like this:













And I have a warning from my flow that this setup could result in an infinite loop, so I need to figure out how to fix that. In order to prevent a loop in a different workflow, I had to add a flag. That can get complicated with an index and telling the flow to set the flag and then check to see if the flag is set in order to not enter the loop. Is there a better way?

Any help on splitting my variable and creating new rows without creating an infinite loop would be huge.


Accepted Solutions
Helper II
Helper II

I posted it over in Power Automate and got a solution over there.

View solution in original post

Helper II
Helper II

I posted it over in Power Automate and got a solution over there.

View solution in original post

Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (24,926)