+4Hello!
Happy Friday.
On SP 2013, we’re looking to create a HTML table output from a repeating section that contains choice fields and list-lookups. Is there a way to insert the actual text, rather than the item #/choice #?
Current Output
Form:
Item = Look-up field (referencing another list), while item status = drop-down choice.
Hoping there could be an ootb solution for this.
Thank you for clarity and guidance!
Best answer by vities
I think I found a solution to this:
The form was originally designed using classics form.
==================================================
To address the Lookup control that I was referencing:
On the form, I added a “Calculated Value” control and used the following formula:
parseLookup(ControlName,true)This returned text/a string, rather than a reference to the list item number.
=================================================
To address the Choice control:
Once again, used a “Calculated Value” control and set it equal to the Control Name, while saving the data type as a string.
I added some rules to these control boxes that would hide these calculated fields from view:
+4I think I found a solution to this:
The form was originally designed using classics form.
==================================================
To address the Lookup control that I was referencing:
On the form, I added a “Calculated Value” control and used the following formula:
parseLookup(ControlName,true)This returned text/a string, rather than a reference to the list item number.
=================================================
To address the Choice control:
Once again, used a “Calculated Value” control and set it equal to the Control Name, while saving the data type as a string.
I added some rules to these control boxes that would hide these calculated fields from view:
+14Did you solve your issue with what you’ve posted?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.