Calculated Value displaying wrong Nintex Form for sharepoint 2013

  • 26 July 2021
  • 1 reply
  • 0 views

I have a list lookup control dropdown at the top of my form with its ID connected to a single line text site column and the list connected to a sharepoint list. Later in the form, I have a calculated value control where I want to display the selected dropdown value from the lookup control at the top of the form. In the calculated value control I have the formula set as the named control of the list lookup column. The issue I am running into is that the calculated value field is displaying the selected drop-down but with "1;#" or "2;#" in front of it. Is there a way to get rid of that?



 



I am having a similar problem with people or group fields that I want to be displayed later in the form through a calculated value control


1 reply

Userlevel 3
Hi,
Use parseLookup() function to trim the "1;#" value. For example you passing ID column to the lookup() function, update your lookup() function with parseLookup(ID).

Reply