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.
Tip The Contains and Is Changed
operators aren't available as filter conditions. In record-triggered flows, Is Changed is
available in Decision elements when the Resource is a field on the
$Record
variable. See Flow Operators in Decision, Wait, and Collection Filter Elements.Tip To count the number of records returned by this element, store them in a
record collection variable and use the Equals Count operator in an Assignment element. See
Flow Operators in Assignment Elements.
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 empty, the flow returns no records.
| 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 | Has no value yet (if you select True for Value) | Boolean |
| In | Matches a value in the collection that you enter 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 you enter 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 you enter or select for Value |
|
| Equals | Matches what you enter or select for Value |
|
| Greater Than | Is larger than what you enter or select for Value |
|
| Greater Than or Equal | Is larger than what you enter or select for Value or is the same |
|
| Is Null | Has no value yet (if you select True for Value) | Boolean |
| Less Than | Is smaller than what you enter or select for Value |
|
| Less Than or Equal | Is smaller than what you enter or select for Value or is the same. |
|
| In | Matches a value in the collection that you enter 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 you enter 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 you enter or select for Value |
|
| Equals | Matches what you enter or select for Value |
|
| Greater Than | Is a later date or time than what you enter or select for Value |
|
| Greater Than or Equal | Is a later date or time than what you enter or select for Value or is the same date or time |
|
| Is Null | Has no value yet (if you select True for Value) | Boolean |
| Less Than | Is an earlier date or time than what you enter or select for Value |
|
| Less Than or Equal | Is an earlier date or time than what you enter or select for Value or is the same date or time |
|
| In | Matches a value in the collection that you enter 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 you enter 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 you enter or select for Value |
|
| Does Not Equal | Doesn’t match what you enter or select for Value |
|
| Equals | Matches what you enter or select for Value |
|
| Ends With | Ends with what you enter or select for Value |
|
| Is Null | Has no value yet (if you select True for Value) | Boolean |
| Starts With | Begins with what you enter or select for Value |
|
| In | Matches a value in the collection that you enter 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 you enter 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, these differences can cause a mismatch:
- 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 you enter or select for Value | Time |
| Equals | Matches what you enter or select for Value | Time |
| Greater Than | Is a later time than what you enter or select for Value | Time |
| Greater Than or Equal | Is a later time than what you enter or select for Value or is the same time | Time |
| In | Matches a value in the collection that you enter for Value. If the collection is empty, the flow stores no records in the output. See Limits in Flow Builder Considerations. | Time |
| Is Null | Has no value yet (if you select True for Value) | Boolean |
| Less Than | Is an earlier time than what you enter or select for Value | Time |
| Less Than or Equal | Is an earlier time than what you enter or select for Value or is the same time | Time |
| Not In | Doesn’t match a value in the collection you enter 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!
