I can get data out of a one repeating section, create items in another list, and update multiline field with a nice HTML table. But, i am not able to do the same more than one repeating section. Can someone put a solution?
Get data out of Nested Repeating Section and HTML
+9
+23- Nintex Partner
Hi,
The output of a repeating section as you know is XML.
If you nest a repeating section inside a repeating section the nested repeating section will be enoded so that it does not mess up the code structure of the XML.
To use this nested Repeating section I first use a query XML action to extract the node that has the nested encoded repeating section.
Then use a build string action with the fn-XmlDecode() Inline function to decode the xml.
Then run that back through the Query XML action to extract the nodes you need.
The output of a repeating section as you know is XML.
If you nest a repeating section inside a repeating section the nested repeating section will be enoded so that it does not mess up the code structure of the XML.
To use this nested Repeating section I first use a query XML action to extract the node that has the nested encoded repeating section.
Then use a build string action with the fn-XmlDecode() Inline function to decode the xml.
Then run that back through the Query XML action to extract the nodes you need.
+9I have tried below approach, the workflwo completed without any error but the items do not get created in another list:
+23- Nintex Partner
Hi,
It is always good to output or log values as you go along to make things easier to debug.
I created an example of debugging and a nested repeating section senario.
Firstly my form. Note that only the Parent repeating section is connected to a SharePoint column. This SharePoint column must be a Multi Lines of Text column configured as Plain Text.
I'm a bit of an F1 fan so I have submitted a form with some racing drivers first and last names.
Two entries in the parent Repeating section which have two child entries.
When this form is submitted the XML in the list looks like this. (I fixed the formatting to make it easier to read.
<?xml version="1.0" encoding="UTF-8"?>
<RepeaterData>
<Version />
<Items>
<Item>
<NestedRepeater type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;First type=&quot;System.String&quot;&gt;Dan&lt;/First&gt;&lt;Second type=&quot;System.String&quot;&gt;Ric&lt;/Second&gt;&lt;/Item&gt;&lt;Item&gt;&lt;First type=&quot;System.String&quot;&gt;Nico&lt;/First&gt;&lt;Second type=&quot;System.String&quot;&gt;Hulk&lt;/Second&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</NestedRepeater>
</Item>
<Item>
<NestedRepeater type="System.String">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;RepeaterData&gt;&lt;Version /&gt;&lt;Items&gt;&lt;Item&gt;&lt;First type=&quot;System.String&quot;&gt;Seb&lt;/First&gt;&lt;Second type=&quot;System.String&quot;&gt;Vet&lt;/Second&gt;&lt;/Item&gt;&lt;Item&gt;&lt;First type=&quot;System.String&quot;&gt;Charles&lt;/First&gt;&lt;Second type=&quot;System.String&quot;&gt;Lec&lt;/Second&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RepeaterData&gt;</NestedRepeater>
</Item>
</Items>
</RepeaterData>
So we can see that the Nested Repeater XML is encoded.
In this example I will just pull out the first name of the first entry in the first nested repeater to show that it is possible. You can expand on this to retreive the rest of the elements data.
First action in the workflow will pull out the first nested XML.
The Information retreived will be encoded so we need a Build String action with an inline function to decode it.
IMPORTANT NOTE: This action needs to be run twice as the XML is not fully decoded on the first pass. This may have been the issue of the poster.
If we look at the output of the build string after the XML decode it will look like this. For debugging create a Multi Lines of Text column in SharePoint configured as plain text and use an update item action so see the output. If it is not formatted properly revist the above steps.
<?xml version="1.0" encoding="UTF-8"?>
<RepeaterData>
<Version />
<Items>
<Item>
<First type="System.String">Dan</First>
<Second type="System.String">Ric</Second>
</Item>
<Item>
<First type="System.String">Nico</First>
<Second type="System.String">Hulk</Second>
</Item>
</Items>
</RepeaterData>
We can now feed this variable into another Query XML action to retreive what ever I want.
I will extract "Dan" in this example.
Now that I have "Dan" stored in a variable I can do what ever I like with it such as creating an item in another list. In this example I have just logged it to the history list for debugging purposes.
Workflow Structure.
+9I am not sure why nothing logs into history. Please find my list, form, and workflow in attachment. I really appreciate for you to looking into this.
+23- Nintex Partner
Hi,
It looks like your XPATH querys are not correct.
First Query Action you have:
/RepeaterData/Items/Item/NestedRepeater
Should be
/RepeaterData/Items/Item[1]/NestedRepeater
Second Query XML action you have :
/RepeaterData/Items/Item/First
Should be :
/RepeaterData/Items/Item[1]/First
Make these two changes and create a new item on your list and test. It worked for me with the files you provided.
It looks like your XPATH querys are not correct.
First Query Action you have:
/RepeaterData/Items/Item/NestedRepeater
Should be
/RepeaterData/Items/Item[1]/NestedRepeater
Second Query XML action you have :
/RepeaterData/Items/Item/First
Should be :
/RepeaterData/Items/Item[1]/First
Make these two changes and create a new item on your list and test. It worked for me with the files you provided.
+9I need your help once more.
How would the workflow change if i wanted to write each repeating section rows in another list? Would you be able to send the .nwf file for the writing all parent and child items into another list?
+23- Nintex Partner
See attached.
I am just logging the two output variables Fout and Sout but you can replace this action with a create item action to create an item with the two variables into two columns.
If you run this on the previous list template I gave you it will read the XML from the repdata column.
It does not matter how many repeating sections are in the master repeater or the Nested repeater this workflow will work it out.
+9Thank you for the solution, it works, one more question please.
I was able to create the items in another list but only for the items inside the child repeating section. In my case i have items inside the parent repeating section too. How would you create items in another list in a same row with items from both parent and child. For example:
Just FYI: I also had to turn off safe looping, and then trun it back after publishing the workflow so it only affected the published workflow.
+23- Nintex Partner
Hi,
It only requires 1 additional Query XML action for every control in the parent.
I have attached a workflow based on the sample list we have been working with and a new form that includes a control in the Parent. I have not included the title but i am sure you know how to add that to a Create Item action :smileyhappy:
Let me know when the bottle of scotch is arriving :smileytongue:
+9@SimonMuntz Much Much Appreciated! I really owe you one. Just for the infomation, blended or straight? ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.