Q: What should I do if the error message “The value of the restricted picklist field is invalid” in Salesforce?
A: If the output values are separated by commas (,), Salesforce does not allow them to be entered due to system limitations.
Use semicolons (;) instead of commas (,) for multiple values.
💪🏼 How to Fix this Issue in Yoom
When Yoom retrieves multiple values, they are comma-separated by default.
To ensure compatibility with Salesforce, you need to convert commas (,) to semicolons (;).
1️⃣ Add a Data Transformation Operation
Before sending data to Salesforce, insert an operation to modify the format of the data.
2️⃣ Select “Replace Data”
Select the Data Conversion action, and choose Replace data.
3️⃣ Configure the Conversion Settings
Set up the transformation to replace commas (,) with semicolons(;).
Before:
"ItemA, ItemB, ItemC"
After:
"ItemA; ItemB; ItemC"
🎉 This should resolve the issue, allowing the data to be properly entered in Salesforce!
🔹 If the Issue Persists
If the error is not resolved after converting commas to semicolons, it may be caused by Salesforce settings.
👉 Refer to the official Salesforce documentation for further troubleshooting: Salesforce Help Article
Search Keywords
Search Keywords
Salesforce, Custom Fields, Picklist, Errors, Data Conversion, Restricted Picklist