- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
In the Incident table, I need to create a new dropdown field. Since the value list is long and dynamic, is it possible to upload the list from an Excel file?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Hi @Vijay Kumar4 ,
> Import into sys_choice Table via Import Sets
Right-click your dropdown field on any record list and select Show Choice List. Export this list to Excel to get proper headers like Table, Element, Value, Label, etc.
>> Prepare your Excel: Ensure you include columns for table and element—they're essential for mapping the dropdown to the correct field.
>> Add your desired choice values.
>> Load and transform: Go to System Import Sets → Load Data, upload your Excel, and choose “Create Table” (makes a staging table).
>> Create a Transform Map from the staging table to sys_choice. Map each field correctly so the records land in the right dropdown.
If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.
Kaushal Kumar Jha - ServiceNow Consultant - Lets connect on Linkedin: https://www.linkedin.com/in/kaushalkrjha/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Definitely possible. We can load the data to system choice table as your requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
@JackieZhang Thanks for your response, could you please provide the steps for that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
1. Go to the data load in left menu. Selected you excel. Servicenow will auto create the import set table.
2. Create transform map between import set table and target table(sys_choice)
map the fields such as Table, Element(field name of drop down list ),Value,Label,Language.
3. run load data again and run transform map
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
yes, you can create a custom table for dropdown values and upload your excel data into the table finally, create reference field on incident table.
To keep dynamic, you need to add/remove values from custom table.
hit helpful and accept as a solution if this solves your issue.
