Loading

CONTAINS operator in Salesforce Process or Flow Does Not Work for Comma Separated Values

Дата публикации: Jun 23, 2026
Описание

The CONTAINS operator in Salesforce Process Builder and Flow Builder checks whether a field value contains a specific string. It does not support multiple comma-separated values in a single condition because each condition evaluates as a single string comparison. When multiple values are entered in one condition (for example, someone@company.com,someoneelse@company.com), Salesforce treats the entire comma-separated string as a literal value to match, not as individual values to evaluate separately.
Passing multiple comma-separated values against the CONTAINS operator in the same condition does not evaluate the Process or Flow as intended.
Example — Incorrectly Configured Process:
Set Filter Conditions: [Case].Contact.Email CONTAINS someone@company.com,someoneelse@company.com
The above process does not evaluate as intended because it includes multiple values separated by a comma.

Решение

Why CONTAINS Does Not Support Comma-Separated Values

Process Builder and Flow Builder do not support comma-separated values in rule criteria. Each condition in a filter evaluates as a single string comparison. To match multiple values, you must create separate conditions for each value and group them using OR logic.

Workaround

Modify the Process or Flow criteria to use one value per Filter Condition, and add additional Filter Conditions as needed. Ensure each Filter Condition is grouped with an OR operator.
Using the same example as above:
Set Filter Conditions:

  1. [Case].Contact.Email CONTAINS someone@company.com
  2. [Case].Contact.Email CONTAINS someoneelse@company.com

Filter Condition Logic (Customize the filter logic): (1 OR 2)

Номер статьи базы знаний

000386764

 
Загрузка
Salesforce Help | Article