How to get external text value in Lookup field be applied correctly?



Question

How to get external text value in Lookup field be applied correctly?

Answer

When a lookup column (SharePoint or Cascading Lookup) has an external value applied to it, the testing process succeeds, but the external value fails to be applied correctly since the lookup’s ID is being read rather than the text value. In order to get the text value in a Lookup field, when you inter the field name in the function, you need to use it in the following format “[FieldName|FieldNameInLookupList]

I did some research and found the way how to get text value in Lookup field.

When you inter field name in the function you need to use it in format “[FieldName|FieldNameInLookupList]

I did some research and found the way how to get text value in Lookup field.

When you inter field name in the function you need to use it in format “[FieldName|FieldNameInLookupList]

I did some research and found the way how to get text value in Lookup field.

When you inter field name in the function you need to use it in format “[FieldName|FieldNameInLookupList]