External Lookup Object ID | Community
Skip to main content
_Manish_Singh
_Manish_Singh
Level 9
May 8, 2025
Solved

External Lookup Object ID

I have a multiselect external lookup field that displays employee names from Workfront user object. This field returns an array of names in the API call, nothing else. I need the user IDs associated with those names. Is there any workaround to obtain that? If getting the ID is not possible, is there a way to display the name and email? Something like this: Manish Singh (manishsingh@domain.com)

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
May 9, 2025

I couldn't find a method to do this, so I created a calculated field to concatenate the username and email. Then I used this field in the external lookup. If there's an easier method, I'd be happy to hear about it.

View reply

2 replies

_Manish_Singh
_Manish_SinghAuthorAccepted solution
Level 9
May 9, 2025

I couldn't find a method to do this, so I created a calculated field to concatenate the username and email. Then I used this field in the external lookup. If there's an easier method, I'd be happy to hear about it.

Translate
Sven-iX
Sven-iX
New Participant
May 9, 2025

Unless you make a Fusion call to compose what you want to return, the calculated field is the way (smart!)

even if you use fusion, we can't return but a single string node per results item (ie cannot return ID + name and only display name).

 

I hope this limitation is addressed at some point

Translate
Terms & ConditionsAccessibility statement

Loading footer...