Regarding the import of reference fields

[tsutsumi mayu]

Please tell me how to prevent groups that do not exist in the assignment group (a reference field) from being imported when importing Excel data into the Change Request table.

[Gangadhar Ravi]

@tsutsumi mayu You can set choice action to rejected in field map of that group field 

[Robbie]

Hi @tsutsumi mayu,

Can you confirm which mechanism you're using to import? Are you using the 'Easy Import' where you down load a template and populate it or using a Transform Map and loading the data?

The 'Easy Import' should (Baseline config) check that the display value for 'Assignment Group' already exists and will throw an Error if it doesn't exist when 'inserting' new data.

If you're using a Transform Map, which provides full control and data manipulation before importing data, you'll need to either handle this as a Before' script or where the field is mapped, implement a script to check for this or select 'ignore' in the choice action.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Community Alums]

Hello @tsutsumi mayu,

In the transform map, there is a field mapping section where you can set the 'Choice Action' to 'Ignore' if no group exists in ServiceNow.

Mark as a helpful or accepted solution.

Thanks