External Lookup Object ID

[_Manish_Singh]

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 · Accepted solution]

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]

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