Split variable collection result from xml output to a sharepoint list multi line of text column
Hello,
Is anyone be able to split a value from variable collection output from XML to a multi line of text in SharePoint list. Building a Nintex workflow but for some reason I was unable to get it working using the Regular Expression or Build String workflow action.
Any help is much greatly appreciated.
Thank you.
Antonio
Page 1 / 1
By the way attached herewith is my Regular Expression and the result of it.
Here is the result I want to accomplish (please see attached).
Thank you for your reply, yeah I have the Query XML as part of my workflow to get the XML value from the repeating section and stored that value in a variable collection. The result of my variable collection is with the semicolon as the delimiter. I want that delimiter remove and split the value to get the result I want but for some reason it does not work.
Hi @aorellano,
Can you provide a sample of the XML output you are working with? I know your issue is with the semicolons, but if they can be avoided to start with, you won't need to remove them.
Hi Simon,
Attached here with is the xml output from the repeating section.
Thank you and much appreciated any helps.
Antonio
Hi @aorellano,
Please see the attached workflow for the solution. It’s just a matter of looping through the collection that is output from the Query XML action and adding it to a build string action.
Result:
Hi Simon,
Sorry for late response here, going to try the solution and let you know if it works.