Skip to main content

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.

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

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.

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")

Beautiful, thank you!

Thank you!

This doesn't seem to work. thanks though

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings