skr35
Canvas Initiate

Calculated Value displaying wrong Nintex Form for sharepoint 2013

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

0 Kudos
Reply
1 Reply
kchaluvadi
Workflow Veteran

Re: Calculated Value displaying wrong Nintex Form for sharepoint 2013

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).
0 Kudos
Reply