Validate user email before data load

VSN
Tera Expert

Hi All,

I am uploading data into ServiceNow table using Import set and trans form maps.

example we can consider the table as program.

when i was upload the data into program table, it contains the a field called "program manager" list type and refer to user table.now i have different users with same name in service now user table. if i upload data it will give result of multiple users to program manager field.

so instead of that i was using email field as reference, while updating the data into import table, i have 2 fields in that template one is" program manager "and another is "program manager email".

when uploading the data user having with the particular email id user only i need to attach to the program manager field in the program table. how to achieve this functionality.

 

1 ACCEPTED SOLUTION

Robert H
Mega Sage

Hello @VSN ,

 

In the Field Map for the Program Manager, use "Program manager email" as the source field and set Referenced value field name to "email".

 

RobertH_0-1745253650756.png

 

That will make the import look up the users by their email address.

 

Regards,

Robert

View solution in original post

5 REPLIES 5

Hello @VSN 

 

Did you look into this? It's the proven best practice method for mapping a column with an email address to a user field in ServiceNow.

 

Regards,

Robert