You are here:
Flow Operators in Data Elements and Record Choice Sets
Filter conditions narrow the scope of records that the flow operates on. For example, use filter conditions to update only the contacts that are associated with the Acme Wireless account. When you add an Update Records element, use filter conditions to narrow the scope to just the contacts whose parent account is Acme Wireless. The In and Not In operators are available only in Create Records, Get Records, and Update Records elements.
Required Editions
| View supported editions. |
Use this reference, organized by the data type of the field that you select, to understand the supported operators.
Checkbox Fields
When you select a checkbox field under Field, these operators are available. A flow treats
null as a different value than false. If you filter for
records whose checkbox field is null, no records are returned.
| Operator | Filters to records where the selected field’s value ... | Supported Data Types |
|---|---|---|
| Does Not Equal | Doesn’t match what you enter or select for Value | Boolean |
| Equals | Matches what you enter or select for Value | Boolean |
| Is Null | Hasn’t been populated with a value yet (if you select True for Value) | Boolean |
| In | Matches a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Data Considerations. | Boolean |
| Not In | Doesn’t match a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores all records in the output. See Limits in Flow Data Considerations. | Boolean |
Currency, Number, and Percent Fields
When you select a currency, number, or percent field under Field, these operators are available.
| Operator | Filters to records where the selected field’s value ... | Supported Data Types |
|---|---|---|
| Does Not Equal | Doesn’t match what’s entered or selected for Value |
|
| Equals | Matches what’s entered or selected for Value |
|
| Greater Than | Is larger than what’s entered or selected for Value |
|
| Greater Than or Equal | Is larger than what’s entered or selected for Value or is the same |
|
| Is Null | Hasn’t been populated with a value yet (if you select True for Value) | Boolean |
| Less Than | Is smaller than what’s entered or selected for Value |
|
| Less Than or Equal | Is smaller than what’s entered or selected for Value or is the same. |
|
| In | Matches a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Data Considerations. |
|
| Not In | Doesn’t match a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores all records in the output. See Limits in Flow Data Considerations. |
|
Date and Date/Time
When you select a date or date/time field under Field, these operators are available.
| Operator | Filters to records where the selected field’s value ... | Supported Data Types |
|---|---|---|
| Does Not Equal | Doesn’t match what’s entered or selected for Value |
|
| Equals | Matches what’s entered or selected for Value |
|
| Greater Than | Is a later date or time than what’s entered or selected for Value |
|
| Greater Than or Equal | Is a later date or time than what’s entered or selected for Value or is the same date or time |
|
| Is Null | Hasn’t been populated with a value yet (if you select True for Value) | Boolean |
| Less Than | Is an earlier date or time than what’s entered or selected for Value |
|
| Less Than or Equal | Is an earlier date or time than what’s entered or selected for Value or is the same date or time |
|
| In | Matches a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Builder Considerations. |
|
| Not In | Doesn’t match a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores all records in the output. See Limits in Flow Builder Considerations. |
|
Picklist and Text Fields
When you select a picklist or text field under Field, these operators are available. The In and Not In operators don’t support picklist fields.
| Operator | Filters to records where the selected field’s value ... | Supported Data Types |
|---|---|---|
| Contains | Contains what’s entered or selected for Value |
|
| Does Not Equal | Doesn’t match what’s entered or selected for Value |
|
| Equals | Matches what’s entered or selected for Value |
|
| Ends With | Ends with what’s entered or selected for Value |
|
| Is Null | Hasn’t been populated with a value yet (if you select True for Value) | Boolean |
| Starts With | Begins with what’s entered or selected for Value |
|
| In | Matches a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Data Considerations. |
|
| Not In | Doesn’t match a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores all records in the output. See Limits in Flow Data Considerations. |
|
Multi-Select Picklist Fields
When you select a multi-select picklist field under Field, these operators are available.
Tip Be careful when using these operators to filter records based on a
multi-select picklist field. Even if two resources have the same items in a multi-select
picklist, they can be mismatched if these cases differ.
- The spacing before or after the semi-colon. For example, one resource’s value is “red; green; blue” and the other’s value is “red;green;blue”
- The order of the items. For example, one resource’s value is “red; green; blue” and the other’s value is “red; blue; green”
For best results, use the INCLUDES function in a flow formula.
Time
When you select a time field under Field, these operators are available.
| operator | Filters to records where the selected field’s value ... | Supported Data Types |
|---|---|---|
| Does not Equal | Doesn’t match what’s entered or selected for Value | Time |
| Equals | Matches what’s entered or selected for Value | Time |
| Greater Than | Is a later time than what’s entered or selected for Value | Time |
| Greater Than or Equal | Is a later time than what’s entered or selected for Value or is the same time | Time |
| In | Matches a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Builder Considerations. | Time |
| Is Null | Hasn’t been populated with a value yet (if you select True for Value) | Boolean |
| Less Than | Is an earlier time than what’s entered or selected for Value | Time |
| Less Than or Equal | Is an earlier time than what’s entered or selected for Value or is the same time | Time |
| Not In | Doesn’t match a value in the collection of data that’s entered for Value. If the collection is empty, the flow stores all records in the output. See Limits in Flow Data Considerations. | Time |
Did this article solve your issue?
Let us know so we can improve!
