Skip to main content
Nintex Community Menu Bar

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

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).


Hi ​@aorellano,

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


Hi 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.


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.

 

Again, thank you for your help much appreciated.

 

 

 


Hi Simon, 

Your solution works.

 

Thank you again.


Reply