cancel
Showing results for 
Search instead for 
Did you mean: 
franco89
Nintex Newbie

Calculated Value from List Lookup Control

Jump to solution

Hi All,

I have a List Lookup control on my form which pulls the "Title" column from a reference list. This column simply contains a number of names.

Eg.

Smith, John

Dimag, Chloe

Johnston, Chris

In my form, I want users to select a value person's name.

I am then using a Calculated Value to draw out the selected value from the List Lookup. But when I do so, the calculated value also seems to contain a prefix including the list item ID?

eg.

"Smith, John" becomes "1;#Smith, John"

Can I correct this? Should I be doing this a different way? The reason I was doing it this way with a calculated value was so that I could extract the person's name and then assign a task to that person's name later in a workflow.

Tags (1)
0 Kudos
Reply
6 Replies
Automation Master
Automation Master

Re: Calculated Value from List Lookup Control

Jump to solution

Hi, have you tried using a parseLookup function to the value you're using right now in your calculated value? It should solve your issue..

Giacomo

View solution in original post

Reply
andersarria
Nintex Newbie

Re: Calculated Value from List Lookup Control

Jump to solution

Hi Dave,

You can use a function to extract only the value without the ID... add a calculated control and use the function "parseLookup(list lookup control reference)". This will extract the value of the control without the ID.

I hope this can help you.

Greetings.

Reply
achilles_aditya
Nintex Newbie

Re: Calculated Value from List Lookup Control

Jump to solution

If parse don't give you result try this

  • Give the Name to your Calculated value (i.e. RawName)
  • Add another calculated value and in formula add userProfileLookup(RawName,"PreferredName")
Reply
franco89
Nintex Newbie

Re: Calculated Value from List Lookup Control

Jump to solution

Beautiful, thank you!

0 Kudos
Reply
franco89
Nintex Newbie

Re: Calculated Value from List Lookup Control

Jump to solution

Thank you!

0 Kudos
Reply
franco89
Nintex Newbie

Re: Calculated Value from List Lookup Control

Jump to solution

This doesn't seem to work. thanks though

0 Kudos
Reply