Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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