Showing results for 
Search instead for 
Did you mean: 

How to Parse value of a lookup control in a calculated Column


If you attempt to pass the value returned in form lookUp Control to a calculated field the value will contain the item ID a semi colon and a pound sign Example 10;#r (r is the actual value)


Use a runtime function in the calculated field Formula:
The easiest way is to use parseLookup()
Example: parseLookup(NamedControl) This will remove all but value

Related Links

Labels: (2)
Tags (2)
Version history
Revision #:
71 of 71
Last update:
‎03-12-2019 07:49 PM
Updated by: