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
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)
Can you please assist?
Thank you very much
Solved! Go 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:
If you have more specific questions, please ask them.
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
and below is how it looks in the sharepoint list item
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
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:
hoping that this will help someone with the same issue