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

External Lookup Object ID

  • May 8, 2025
  • 1 reply
  • 443 views

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)

Best answer by _Manish_Singh

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.

1 reply

_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.

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
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

Terms & ConditionsAccessibility statement

Loading footer...