Loading

List view error: 'Picklist Value does not Exist'

Udgivelsesdato: Oct 13, 2022
Beskrivelse

The error Picklist Value does not Exist may appear when creating or editing list views that are filtered on picklist fields.  

Løsning

When creating a list view where the search criteria is based on a picklist field, it is only possible to enter up to 80 characters (including spaces).  Because of this, we suggest checking the final vaue in your filter criteria to ensure that the full field value was added to your filter criteria.  If the full value was not added, users can create an additional line of filter criteria to ensure that values that exceeded the initial 80 character limit will be reviewed.  Users can then use the "OR" function within the Advanced Filter Criteria to ensure that both lines are reviewed when the picklist is executed.  

For Example:
Click on the lookup box to display the picklist values in the search criteria.
If the character length for all the values selected is 100, then roughly 20 characters will be cut off.  If the cut off point occurs midway through one of the picklist values, then it will throw the error message noted above.



This error can also be returned if a picklist value contains a comma. Picklist values that contain commas need to be placed in quotes when used in filter criteria.

 

Another possible, but less common, cause is that the user creating the list view is using a locale other than English, and the translated picklist value they are filtering on is the same as an inactive picklist value.  The solution for this occurrence is to delete the inactive value causing the error.

For example:
Suppose a picklist contains an inactive value called "Interno", as well as an active value called "Internal" and an Italian translation for this. Because the Italian translation is the same as the inactive value, when an Italian user tries to create or modify a view using this value, the error will be returned. 


Note: This error will also appear in reports when filtering based on a picklist field.
Vidensartikelnummer

000385195

 
Indlæser
Salesforce Help | Article