+4Hello,
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
Best answer by SimonMuntz
Hi
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:
+23Hi
Nintex for SharePoint has a Query XML action that can parse XML.
Have you tried that?
https://help.nintex.com/en-US/nintex2019/current/sp2019/Workflow/ActionsCore/ReadXML.htm
+4Hi Simon,
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.
+23Hi
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.
+4Hi Simon,
Attached here with is the xml output from the repeating section.
Thank you and much appreciated any helps.
Antonio
+23Hi
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:
+4Hi Simon,
Sorry for late response here, going to try the solution and let you know if it works.
Again, thank you for your help much appreciated.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
