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.
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?
"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.
Solved! Go to Solution.
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.
If parse don't give you result try this