You need to sign in to do that
Don't have an account?

Bad value for restricted picklist field
Hello community
I'm struggling with a small error which I can't seem to find an answer to. Can you help?
[{"message":"bad value for restricted picklist field: Bristol","errorCode":"INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST","fields":["RM_Region__c"]}]
There are scores of picklist values within "RM_Region__c". For some reason, "Bristol" is being rejected.
The closest I can get to a possible answer is that "Bristol" needs to be allocated somewhere for it to work?
I'd really appreciate any ideas the community have.
Many thanks and look forward to hearing from you.
I'm struggling with a small error which I can't seem to find an answer to. Can you help?
[{"message":"bad value for restricted picklist field: Bristol","errorCode":"INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST","fields":["RM_Region__c"]}]
There are scores of picklist values within "RM_Region__c". For some reason, "Bristol" is being rejected.
The closest I can get to a possible answer is that "Bristol" needs to be allocated somewhere for it to work?
I'd really appreciate any ideas the community have.
Many thanks and look forward to hearing from you.
This is happening because the picklist you are passing is not defined under picklist values. So, if you are passing value which is not available inside picklist, then it will restrict you to continue.
This is due to "Restrict picklist to the values defined the value set" checkbox present under field defination.
For example:
Intially if you have picklist having value as defined:
- A
- B
- C
and also you have "Restrict picklist to the values defined the value set" is checked. Then it will not allow you to pass value of thie picklist as "D".But if you unchecked "Restrict picklist to the values defined the value set" checkbox, then it will allow you to pass any value like "D" and keep adding this value to the picklist.
Here are screenshot:
Before uncheck "Restrict picklist to the values defined the value set"
After unchecked "Restrict picklist to the values defined the value set"
I hope this will give you deep understanding.
If this helps you, mark this question as solved and choose best answer so it will help other in future to choose best solution.
Thanks
Gulshan Raj
When are you getting this error message? Can you please elaborate?
It shouldn't happen beacuse there are scores of entries in the picklist, including Bristol, but it only rejects Bristol.
If you are using Record Types, go to the record type setup and in the Picklists Available For Editing, find the picklist in question. You will likely see that your "problem value" is not in the Selected Values column. In researching this issue I found that one of our developers deleted the original value and then added it back with the same value shortly after, likely a mistake. But, they forgot to update the record type.
https://help.salesforce.com/articleView?id=000250168&language=en_US&type=1
Hope it helps.
Swapnil
You saved me from agonizing headache after I encounted this exact bloody problem..