How to add multiple items in Question Choice?

[Vengeful]

Hi,

We have a variable type select box Report Name. And we need to add more than 20 Question Choices.

How can I add it via import?

[Sujit Jadhav · Accepted solution]

To add more than 20 question choices to a variable of type select box (dropdown) in ServiceNow via import, you can use the Import Sets functionality. Here's a step-by-step guide:

Prepare Data for Import:

Create a CSV file containing the data you want to import. Each row should represent a question choice.
Ensure that the CSV file has a column header that matches the variable name (e.g., "Report Name") to which you want to add choices.
Set up an Import Set Table:

Navigate to "System Import Sets" > "Import Sets".
Click on "New" to create a new Import Set table.
Define the table and field mappings for your CSV file. Map the "Report Name" column from your CSV to the appropriate field in the Import Set table.
Upload the CSV File:

Go to "System Import Sets" > "Import Sets".
Click on the Import Set table you created in step 2.
Click on "Load Data" and upload the CSV file.
Transform and Validate Data:

After uploading, ServiceNow will attempt to transform and validate the data.
Ensure that the data is correctly mapped and transformed. ServiceNow will highlight any errors or issues that need to be addressed.
Import Data:

Once the data is successfully transformed and validated, click on "Commit" to import the data into ServiceNow.
Verify the Variable:

After the import is complete, navigate to the form or table where the variable of type select box (dropdown) is located.
Check the list of choices for the "Report Name" variable to ensure that the new choices have been added successfully.
By following these steps, you should be able to import more than 20 question choices into a variable of type select box in ServiceNow efficiently. Make sure to review the data and mappings carefully to avoid any errors during the import process.

[Vengeful]

Hi @Sujit Jadhav 

I can't find these:
Navigate to "System Import Sets" > "Import Sets".
Click on "New" to create a new Import Set table.

[Sujit Jadhav]

Navigate to System Import Sets > Advanced > Import sets

or

You can use below mention method:

Then you can use Load Data function

I hope this solution find you helpful.

[Jim Coyne]

You might want to take a look at this: "Add Multiple 'Question Choice' Records" Tool

It was created to help with this exact scenario.

BUT, you may also want to expand on the usefulness of your solution by using a Reference field instead and point to the Reports table.  You could add a checkbox field on that table which you would use in the Reference Qualifier.  The field would be something like "Allow users to request access" or something.  That way you would just check the field on the Report record for new reports and it would magically appear/disappear in/from the list instead of having to keep adding/removing report names from the drop-down list.  Might have to play with some ACLs to get it to work, but it might be worthwhile as it would cut down on some maintenance.