I am currently working on a Sharepoint list where i am using nintex forms to help with the functionality.
In this list the user needs to be able to add as many machines that they are using for a job with all the needed info required by the company. For this i decided to use the repeating section within nintex.
In the repeating section i have columns such as Description, Weight, Dimensions, How is the machine powered, etc.
But nintex doesnt have an out of the box solution how this data can be easily stored in the columns of my Sharepoint List.
I have tried looking for a solution on this forum but the answers i got were either out of date or were too complex for me too understand (Total noob to nintex).
Repeating section data gets saved as XML and i want to extract this data and put it into the relevant columns of the Sharepoint List.
Can anyone help me walk through this problem and how i can solve it? (I am using the new responsive designer btw)
Many thanks in advance,
@JaredA You will need to parse the xml, there is a sample and example here(http://workflowexcellence.com/nintex-workflow-parsing-nintex-forms-repeating-section-in-office-365/). The main difference in new responsive is the names of the field will be guid's like the following(_8eb4d91752f381f525f0dbf08da6a794) rather than a name mentioned in the example.
Couple of things first.
1. Copy the XML from your form output into a notepad file with the extension ".xml". (You hinted this might be connected to a SP list column?)
2. On the workflow side, you will now want to configure a Query XML action. In this action,
3. Add and configure a collection operation. In this action,
4. Add a set variable action where you set a new variable titled "Counter" of type integer to a value of 1.
5. You will then want to start looping through the data. Create a loop action with the following values,
6. Add and configure another Query XML action. In this action,
7. Use this SLT to update any list item of your choosing. I usually output the results of a repeating section to a different list.
8. Add a math operation and add 1 to the workflow counter variable.
9. This should close your loop.
I like yourself, am also new to Nintex. The above took a ton of trial and error, as well as multiple articles to get my scenario right.
Feel free to provide more details if this does not work.
I realize after posting my lengthy response, I didn't address adding this info back into the list.
For this, you can set up a conditional statement inside the loop after the Query XML part but before the Math (add +1) function.
1. Add a Set a Condition module inside the loop,
2. For the "Yes" part of this condition,
3. For the "No" part,
Thanks for the very detailed explenation!
Im still having some problems with your solution.
For the Query XML action:
-When you say "Change the XML source to XML", there are only 2 options in Nintex workflow which are "Existing SharePoint content" and "Content". Which one of these should i click on?
-Do i need to return the results as "Text", "Inner XML", or "Outer XML"?
For the collection operation:
-The only collection operation that seems logical to use would be the "Add item to collection" operation, is that correct?
-In the "Add item to collection" operation i don't have anywhere where i can select count, which is why i think that i might not be using the right operation or we might be using different versions/platforms. Not sure about this.
For the Math operation:
Just like the collection operation, i can't seem to find this operation within Nintex Workflow.
Maybe it's just going right over my head but what should this function be called in the list of actions?
At this point i can't really test if this solution will work for me because of the missing operations.
Please let me know if i am doing anything wrong or i am just missing simple things.
I will try to answer your questions as best I can!
-Query XML Action
Hopefully these operations are available to you. If they aren't, I would double check your Nintex config and make sure these actions are available.