Get Repeating Section data in new responsiver designer

  • 30 August 2019
  • 7 replies
  • 55 views

Badge +8

There are several posts here about using Nintex Workflow to get data from a Nintex Form repeating section.  The trick is to create a list column of multi-line text and set your Repeating Section control's "Connected to" setting to that multi-line column, and Workflow can parse the XML output stored in that column.

 

Well, I noticed something different in the new responsive designer.  Normally when you add a control into the repeating section, you can name the control and that name will be used in the XML output, so you can set your XPath query to //<controllname>.

 

In the new responsive designer, the XML output uses random numbers instead of the name you gave the control.  Thus the XML looks like this,

 

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version>1.0</Version><Items><Item><_d1c6bb8c4ea50881a5b6e43e1e6ca973 type="System.String">user input here</_d1c6bb8c4ea50881a5b6e43e1e6ca973> etc

 

Therefore, to get the data I had to set my XPath query to

//_d1c6bb8c4ea50881a5b6e43e1e6ca973

 

Hope this helps someone.


7 replies

Userlevel 6
Badge +22

HI,


New Responsive forms are still being developed and features are being added at a rapid pace.


Repeating sections were not even in the first release.


I tested the issue you are facing and you are correct that this is the current functionality.


 


@EuanGamble will this functonality change in the future so that it behaves like Repeating Section output in Responsive and Classic Forms?

Userlevel 5
Badge +13

Hi @SimonMuntz  and @plamping,


 


Thanks for bringing this to my attention. I will speak with the development team regarding this.


 


Cheers,
Euan

Badge

Hi Euan,


Any news regarding this issue? I've tried this week and the XML is still containing strange codes instead of the field names. I could use these codes but I wonder if they won't be changed if I move the application to production...


Thanks in advance.


Best Regards,


Franck

Userlevel 5
Badge +13

Hi Franck,


 


I have been discussing this with the team and it is a complex piece of work. It is certainly something we plan to do, but we do not have an ETA at this point.


 


Cheers,


Euan

Hi Euan, 


 


Any Update on this discussion?


 


As we are facing the same issue. We are migrating SharePoint sites for our client from SharePoint 2016 to SharePoint O365. We have created forms using the New Responsive designer with the repeating section. But generated XML columns are different than what we have on the SharePoint 2016.


 


As a result, for items which are migrated from SharePoint 2016, repeating section fields shown blank on the form.


 


Old XML:


<?xml version="1.0" encoding="utf-8"?>


<RepeaterData>


   <Version />


   <Items>


      <Item>


         <_x0031_d59c1be-cc09-434a-933b-f24949f87c8a type="System.String">8</_x0031_d59c1be-cc09-434a-933b-f24949f87c8a>


         <ItemCategory type="System.String">13</ItemCategory>


         <ItemDescription type="System.String">182</ItemDescription>


         <de0a3d6a-902f-4d2d-aa6f-04147c61ae87 type="System.String">PAP305100</de0a3d6a-902f-4d2d-aa6f-04147c61ae87>


      </Item>


   </Items>


</RepeaterData>


 


New XML:


<?xml version="1.0" encoding="utf-8"?>


<RepeaterData>


   <Version>1.0</Version>


   <Items>


      <Item>


         <_6wba637WZNv type="System.String">6</_6wba637WZNv>


         <_SxHPl7FwdZD type="System.String">34</_SxHPl7FwdZD>


         <_da426644667c4677cbde8128c091d9b8 type="System.String">BRU302200</_da426644667c4677cbde8128c091d9b8>


         <_4aa242adaf4e3a809a8dfed41d310ea3 type="System.String">5</_4aa242adaf4e3a809a8dfed41d310ea3>


      </Item>


   </Items>


</RepeaterData>

Userlevel 6
Badge +22
Hi,

You could ryun a workflow over the XML that does a find and replace to replace the old names with the new names. Then the items will display correctly on the new form.
Badge +3

Hi @SimonMuntz , 


 


I have a requirement to display the repeating section from the list on to the task forms. I am using new responsive nintex forms. I have connected it with a multiple line of text field. I thought I will be creating a repeating section on the task form with same column names and will be connecting with the Related list column. Unfortunately it creates blank rows on the task form. 


 


Is it happening because of the random numbers in the XML? Is there any workaround for this one?


 


Kind Regards,


Nausheen

Reply