How to get Email Address of users in reference field

[Akshat8]

Hello All , My requirement is that I have to get Email Address of users in reference field and not name of the user. Any solution for this. Thanks in advance. 

[Manmohan K]

Hi @Akshat8  

1. Create another variable of type single line text called "Email of Engagement User".

2. Set that variable "Email of Engagement User" to read-only

3.  In the record producer/service catalog navigate to the "Catalog Data Lookup Definitions" tab and create a new record with the below details.

4. In the above created catalog data lookup definition "Set Email", navigate to the "Catalog Matcher Definition" tab and create a new record as below. In my case the variable name is "users", you will have to select the variable name  - Email address of engagement user who needs the permissions

5. Navigate to the "Set Email" catalog data lookup definition created in the step 3 and create a new "Catalog setter variable definition: as below.  Source variable name for you would be Email of Engagement User"

Now you can navigate to portal and test by selecting Engagement User, the email address will be auto populated.

[Akshat8]

Hey @Manmohan K Thanks a lot for your help but actually I don't want it to autopopulate email address based on any name....I want to display the email address in reference field.

[Manmohan K]

@Akshat8  

Its not possible for variable to show email address unless you change display value of sys_user table to email which is not a recommended approach

However you can go with Ravi's approach and change the variable type to lookup select box

[Gary Larsen]

Morning

I have this working great except I am using requested for as a source variable which auto pops when the item opens. so when the item opens the email does not auto pop but if I change the requested for to another name the email auto pops. then when I change it back to original name it also auto pops. I have change the run when to update, changes , and inserts and all combos any ideas ?