- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2025 09:09 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-21-2025 09:42 AM
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".
That will make the import look up the users by their email address.
Regards,
Robert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2025 09:42 AM - edited ‎04-22-2025 09:42 AM
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