AnsweredAssumed Answered

Calculated Value from List Lookup Control

Question asked by franco89 on Jul 27, 2016
Latest reply on Jul 28, 2016 by franco89

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.

Outcomes