How to show display value instead of sys id in the lookup list?

[Jessica28]

Hello,

I have a custom table with two columns, Project Number and Project ID

When I clicked on the lookup using list (magnifying glass) on the Project Number variable, it shows the sys_id's list.

How to I change it to show display value?

The display field is already set to true

Thank you

[Alp Utku]

Hello,

Please see this KBA below

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0782993 

[SanjivMeher · Accepted solution]

Hello @Jessica28 ,

After clicking the lookup, right click on the header of the list and click Configure->List Layout and add the required columns you would like to display there.

Also make sure, you dont have sn-utils added the sysid field. Because usually the sys id field are not selectable in list view.

[Sumanth16]

Hi @Jessica28 ,

Check if the display value of the Project Number and Project ID fields are on your table. The default for custom tables & some OOB it is "sys_id".

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda