Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Salesforce FSHCSalesforce FSHC 

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.
Dutta SouravDutta Sourav
Go to the RM_Region__c Picklist and make the following change:
User-added image
GulshanRajGulshanRaj
Hi @Salesforce FSHC,

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.
User-added image



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"
User-added image

After unchecked "Restrict picklist to the values defined the value set"  
User-added image


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


 
Salesforce FSHCSalesforce FSHC
Thank you. I think we're nearly there. Bristol is in the picklist, which is what is confusing. However, I don't see what you see. Any advice?

User-added image
Dutta SouravDutta Sourav
Okay. So you have used Global Picklist. Then this option will NOT be available.
When are you getting this error message? Can you please elaborate?
Salesforce FSHCSalesforce FSHC
I get it when a mailparser forwards an email to Salesforce. Salesforce rejects it. 

It shouldn't happen beacuse there are scores of entries in the picklist, including Bristol, but it only rejects Bristol.
Nicholas BorowiecNicholas Borowiec
I had this same problem and hopefully this post will save somebody some time in the future. The symptom is as described above, the picklist value giving the error is definitely in the list of values, and you only get the error for this 1 (or possibly several) values.

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.
Swapnil Patne 20Swapnil Patne 20
Hi all, just as a reference - this article explains why users get  Error 'Bad value for restricted picklist field' when creating records / when attempting to create a record, users may notice an error message:

https://help.salesforce.com/articleView?id=000250168&language=en_US&type=1 

Hope it helps.

​Swapnil 
 
William Linke 1William Linke 1
Just want to say thanks to Nicholas Borowlec for his post above!  That was exactly the problem I faced, and I didn't realize that record types can control which values can be used in a picklist!
Seetha Arulprakash 3Seetha Arulprakash 3
Thanks Nicholas Borowiec. Saved a lot of time!
Smita HodiggeriSmita Hodiggeri
Thank you @Gulshan Raj this helped me resolve my issue! 
David Roberts 4David Roberts 4
I had a similar issue using dependent fields on an opportunity stage. I needed to set my record's stage as 'closed won' or 'closed lost'  in order to use the corresponding 'reason why won' and 'reason why lost' values. I then found I couldn't 'extend' my object! This was because I'd not included StageName in my data record. 
<force:recordData aura:id="frd"
     fields="Name,Amount,Account.Name,Reason_Won__c,StageName"
     recordId="{!v.recordId}"
     targetError="{!v.recordError}"
     targetRecord="{!v.record}"
     targetFields ="{!v.theOppRecord}"
     mode="EDIT" />

 
Victor LockwoodVictor Lockwood
@Nicholas Borowiec you're a lifesaver, thank you!
Leonardi KohLeonardi Koh
Much appreciated Nicholas Borowiec,

You saved me from agonizing headache after I encounted this exact bloody problem..