BigBlockChevy
Forms Fledgling

Extracting Repeating section data to a single column

Jump to solution

Hello 

 

basically i have a workflow that was developed with InfoPath and now its my job to migrate that onto Nintex. My issue is that i want to extract each repeating section row data into a SINGLE multiline column on a SINGLE SharePoint list item to perform collection calculations in the workflow

 

below is the repeating section

Snip.PNG

 

and for every item that gets added into a new repeating section row, a new line in the same column like the below will be added)

Snipe.PNG

Can you please assist?

 

Thank you very much

0 Kudos
Reply
4 Replies
MegaJerk
Automation Master
Automation Master

Re: Extracting Repeating section data to a single column

Jump to solution

If you're just doing processing on the data via workflow, then you can likely save yourself a lot of trouble by just processing the bulk XML generated by the Repeating Section when the Form is Saved (assuming you have the Repeating Section associated to a multi-line text column on the list the Form is on). 

If you'd like to know more about that, there are several forum posts here on how to accomplish the task of parsing repeating section data / xml, as well as a few external blogs: 

 

 

However, if you really do wanna make different items on a different list that correspond to a Repeating Section on a different list, then this guide should get you started: 

Nintex Workflow - Order and Order Items Relationship

 

If you have more specific questions, please ask them. 

 

 

 

Reply
BigBlockChevy
Forms Fledgling

Re: Extracting Repeating section data to a single column

Jump to solution

Thank you for the prompt response.

 

the problem am having is that i have to extract specific network port, protocol, and type data from each repeating section row, then check each one against a different list and based on a condition which will determine the next approval stage.

 

it currently works since in InfoPath there is a Concat() functions that gets the data from each repeating section row and puts it in a separate line on the same column.

 

Below is how it looks in InfoPath form

Snip.PNG

and below is how it looks in the sharepoint list item 

Snipe.PNG

 

am looking to do the same on Nintex forms without having to change the workflow since i have alot of forms that needs migrating and i already wasted quite some time on this alone

 

Again thank you very much for the help

0 Kudos
Reply
BigBlockChevy
Forms Fledgling

Re: Extracting Repeating section data to a single column

Jump to solution

so after three days of researching ive figured a better way to do this without having to parse the XML with a minor change in the workflow, below is what i have done since the repeating section had 8 fields and i only needed to query 3 fields against another list:

  • added a calculated field inside the repeating section that combines the fields and added "&"  as delimeter to be removed in the workflow

Capture1.PNG

  • added a form variable with a replace action (to remove brackets from the above control) and added the calculated value control to it, then connected it to a column 

Capture2.PNG

  • in the workflow ive used a regular expression action that will split the required fields and stores the results in a collection to compare with the external list (had to create an additional column in the external list that combies three columns for comparison in the workflow)

Capture3.PNG

 

hoping that this will help someone with the same issue

View solution in original post

Reply
MegaJerk
Automation Master
Automation Master

Re: Extracting Repeating section data to a single column

Jump to solution

An excellent solution! Good to hear you got it worked out! 

0 Kudos
Reply