Skip to main content
All Collections🔗 Integration with External Services (Apps)Salesforce
How to Fix the "Invalid Value for Restricted Picklist Field" Error in Salesforce
How to Fix the "Invalid Value for Restricted Picklist Field" Error in Salesforce

As of September 19, 2023

Yoom 青柳 avatar
Written by Yoom 青柳
Updated over 2 weeks ago

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(;).

  1. Before: "ItemA, ItemB, ItemC"

  2. 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

Salesforce, Custom Fields, Picklist, Errors, Data Conversion, Restricted Picklist

Did this answer your question?