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.