Question

How to extract data from an existing repeating section into a SharePoint column?

  • 7 March 2023
  • 1 reply
  • 175 views

Badge +1

I have a SharePoint 2013 list that is using Nintex forms and has a repeating section that was not connected to a multiline of text from the beginning. I have created a workflow to get the FormData from the form and copy it to a multiline field. I then clean up the XML and want to get the values from my repeating section to use in other columns. The issue I’m having is that the XML is returning with extra information that I need to remove from the string. The code that’s returning is below

<?xml version="1.0" encoding="utf-8"?>
<FormVariables>
<Version />
<InvoiceRepeatingSection type="System.String">
<?xml version="1.0" encoding="utf-8"?>
<RepeaterData>
<Version />
<Items>
<Item>
<AccountNum type="System.String">5112</AccountNum>
<CostCode type="System.String">5573</CostCode>
<ProgramCode type="System.String">4649</ProgramCode>
<DollarAmount type="System.Decimal">63.01</DollarAmount>
</Item>
</Items>
</RepeaterData>
</InvoiceRepeatingSection>
</FormVariables>

When I try to use this code in my query XML action the tree view doesn’t show the items and the test run returns the same exact code. My question is how can I extract the values from the item nodes or update my XML to remove the extra tags? 


1 reply

Userlevel 5
Badge +13

It looks like you can get to the data you need if you remove the second “<?xml version="1.0" encoding="utf-8"?>” line right after the InvoiceRepeatingSection node.

 

To get the AccountNum (or other data), you can then use the XPath Builder to get the correct XPath. For example, here’s the XPath for AccountNum:

/FormVariables/InvoiceRepeatingSection/RepeaterData/Items/Item/AccountNum

Reply