Variable type 'Lookup Select Box' display value is sys_id not name

rjan
Kilo Contributor

I have a variable with a type 'Lookup Select Box'. Which is a reference to the sys_user_grmember table. When choosing an option, it displays the users name, once the request has been submitted, it shows the sys_id in the variable. See screen shots.

When requesting something:

When requesting the item.PNG

Once its been requested:

Once the item has been requested.PNG

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

Hi R Jan,



Which field is display=true on sys_user_grmember table. if no field is display=true then it will show sys_id in the lookup field


Have a particular field as display=true and then check the lookup field what it shows.




Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.


Thanks


Ankur


Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Jaspal Singh
Mega Patron
Mega Patron

Hi,



Check for display value for sys_user_grmember table. Make sure you have display value set to User or Group as required & no other field on the table has dictionary override marked as true.



find_real_file.png



find_real_file.png



Also, check for dictionary override by looking at some tabs below the same form.


Michael Ritchie
ServiceNow Employee
ServiceNow Employee

Please do NOT change the display value as noted in the other responses as that will mess up your existing reference fields.



Lookup select boxes have a "Lookup label field" attribute that you need to set:


find_real_file.png


This is what it currently looks likes, what should I update it with? Thanks


Type Specs.PNG