Loading

Data Loader/Data Import Wizard Adds "Invalid Values" to Picklist

게시 일자: Nov 20, 2025
상세 설명

This article explains a phenomenon where unintended "Invalid Values" are added to a Picklist field when Service or Sales records are created or updated using the Data Loader or Data Import Wizard. 
This behavior occurs when the "Restrict picklist to the values defined in the value set" setting is disabled.

솔루션

Overview
This is the expected behavior based on standard Salesforce functionality.


Cause

If the "Restrict picklist to the values defined in the value set" checkbox is unchecked (disabled) in the picklist field settings, Salesforce accepts the value and adds it to the list as an "Invalid Value" when data containing a value not defined by the administrator is imported.


Solution

To prevent data other than the defined values from being imported, enable the restriction using the following steps:

  1. Click Setup | Object Manager.
  2. Select the target object and click Fields & Relationships.
  3. Click the target picklist field.
  4. Click Edit.
  5. Check the box for "Restrict picklist to the values defined in the value set".
  6. Click Save.

Enabling this setting will cause an error when attempting to import or update records that contain an undefined value, preventing unintended values from being added to the system.

Knowledge 기사 번호

005228870

 
로드 중
Salesforce Help | Article