Auto-populate functionality doesn't work on back-end and it shows empty field for the catalog form

jeffreygard1127
Tera Contributor

Hi guys, on our catalog form, I created 3 new fields 
1. Select user

2. Department

3. Email Address

 

All fields are reference type and reference to sys_user table. 

 

For the Department and Email address field, I used the functionality "Auto-Populate" and the dependent question is the "Select User"

 

IMAGE 01.jpg

 

It is working properly on the portal. Whoever I selected as user on the "Select user" field, it will just auto-populate the Department and Email field.

 

IMAGE 02.jpg

 

However, on the back-end, the Department and Email Address field is EMPTY

 

IMAGE 03.jpg

 

does anyone know how to fix this?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@jeffreygard1127 

If the variable type and the field type from where you are fetching are different then it won't work.

Department variable should be referring to cmn_department table and it should fetch value from Department field from sys_user.

Email variable should be single line text and not reference.

Please do the above changes and share feedback

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

View solution in original post

6 REPLIES 6

BrianProvencher
Giga Guru

Do the Department and Email Address fields have the same system name as the ones in the catalog item? 

Yes, it's the same

AkashM915112357
Tera Contributor

Hello @jeffreygard1127 

 

You have to add this into your Flow desginer RITM request part then it will assign in the Backend part.

Please check your Flow as well.

 

If my response helped please mark it correct.

Ankur Bawiskar
Tera Patron
Tera Patron

@jeffreygard1127 

If the variable type and the field type from where you are fetching are different then it won't work.

Department variable should be referring to cmn_department table and it should fetch value from Department field from sys_user.

Email variable should be single line text and not reference.

Please do the above changes and share feedback

If my response helped please mark it correct and close the thread so that it benefits future readers.

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