Need to Display Email ID Next to Name in List Collector (Watch Parties) for record producer variable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
Hi Team,
I am facing an issue with a Record producer variable configuration and need your guidance.
Scenario:
We have a variable called Watch Parties in a the item. It is a List Collector mapped to the Watch list field and uses the sys_user table. When searching for users in this field, only the Name is displayed.
This creates confusion because we have multiple users with the same name (e.g., Santhosh Kumar). For fields like Requestor and Affected User, the system shows the email ID next to the name, which helps identify the correct person. We need the same behavior for Watch Parties.
Current Configuration:
- Variable Type: List Collector
- List Table: sys_user
- Reference Qualifier: javascript:active=true^sourceLIKExOU=Users^ORsourceLIKExOU=Contractors^ORsourceLIKExOU=Partners^ORsourceLIKExOU=External^nameISNOTEMPTY^EQ
- Variable Attributes Tried : ref_ac_display_value=true,ref_ac_columns=email,user_name
Methods I Tried:
- Added ref_ac_columns=email,user_name in Variable Attributes → No effect.
- Tried ref_ac_display_value=true → No change.
- Checked for Display Templates → Not available in my instance.
Expected Outcome:
When searching in the Watch Parties List Collector, I want to see: Name | Email |
similar to Requestor and Affected User fields.
But its not working, Any help or best practice would be appreciated!
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
when you use ref_ac_columns attribute then it will show the Name and Email when user types in.
But when they select user it will always display Name as that's OOTB display field on the sys_user table
If you want to show Emails of the selected users, then create another multi-line text variable and then auto populate it whenever list collector value is selected
this link has solution from Asif for this
Populate Email Addresses of users selected in List Collector variable to Multi Line Text Variable
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
