Solved

Nintex Online Forms - Collect title value from lookup list drop down instead of the ID value?

  • 20 June 2019
  • 2 replies
  • 20 views

Badge +8

Nintex O365 Responsive forms...

I have a repeating section on a form with 2 lookup fields in it. The XML generated displays the ID if the selected values, not the title.  See the Site collection value of 53 and the SelectSites values of 55, 53, 60, 66, 67. What can I do to get the value of the lookup list title column and not the ID.

 

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><SelectSiteCollection type="System.String">53</SelectSiteCollection><SelectSites type="System.String">55;#;#53;#;#60;#;#66;#;#67;#</SelectSites><Select_x0020_Permission_x0020_Level type="System.String"> Contribute (Add/Edit/Delete Content)</Select_x0020_Permission_x0020_Level><SpecialSharePointAccess type="System.String"></SpecialSharePointAccess></Item><Item><SelectSiteCollection type="System.String">3</SelectSiteCollection><SelectSites type="System.String">14;#;#18;#</SelectSites><Select_x0020_Permission_x0020_Level type="System.String">Visitor (Read/View Only)</Select_x0020_Permission_x0020_Level><SpecialSharePointAccess type="System.String"></SpecialSharePointAccess></Item></Items></RepeaterData>

icon

Best answer by nico 21 June 2019, 16:49

View original

2 replies

Userlevel 4
Badge +10

This is normal, it's the way the repeting section save values of list lookup.


 


But, if you want to save the Text of your listLookup in the XML that your repeting section generate, you can ADD a "Calculated value" in your repeting section whitch display the text of your listLookup control. (use the function parseLookup to get only the text in the formula of your calculated value). In this way, the text of your control "Calculated value" will be save in the XML of your Repeting section.


 


And you can add a rule on the calculated control, with formula "1==1" and action set to hide, to hide this text from the user (the value of your control caculated value will be saved)


 


 


 

Badge +8
It worked. Many thanks!!

Reply