How to setup lookup field for user email ID?

[B Ashok]

Hello Team, 

I would like to setup a lookup field "user email ID" in catalogue ITEM , which reference table I need to use. When I use sys_user, I am getting user ID not email ID. but I need email ID lookup. 

Can you please help. 

Thanks in advance. 

[Elijah Aromola]

You need to add/modify the ref_ac_columns attribute on the dictionary entry to have the email field.

Directly from the docs:

For example, ref_ac_columns=user_name;email;sys_created_on allows auto-complete to match text from the user_name, email, and sys_created_on columns.

https://docs.servicenow.com/en-US/bundle/vancouver-platform-administration/page/administer/field-adm...F

[B Ashok]

@Elijah Aromola  I would like to setup a lookup field "user email ID" in catalogue ITEM