- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2022 07:13 AM
Hi there, I have created a Data source of type excel. When I load data, data will get inserted into Resource plan table.
I found an observation on this.i.e,
For suppose I have filled some value under 'Requested for' column in excel who is not an user. The data is getting imported still and creating some bad data.
I need to validate the value for 'Requested for' column before the data gets imported. How is it possible? If it is possible using some script in Transform map script please provide the script as well.
Thanks in advance
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2022 09:46 AM
Hi,
in the excel you are getting user's user_name or email?
if you are getting user_name then in Referenced value field name give user_name
if you are getting email then give email
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-08-2022 09:46 AM
Hi,
in the excel you are getting user's user_name or email?
if you are getting user_name then in Referenced value field name give user_name
if you are getting email then give email
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2022 03:35 AM
Hi Ankur,
One last thing. Does it works for List type field which has the slushbucket attribute?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2022 04:02 AM
Hi,
Did I answer your original question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2022 04:03 AM
Hi,
please use field map script and return array of sys_ids
In the referenced value field name give sys_id
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader