Filter Step | Formt

Step Guide: Filter

Flow Control

Filter data by condition

Overview

The Filter step removes elements from an array based on conditions you define. It outputs a list array of matching elements and a list_count, making it useful as an intermediate step between data sources and For Each loops.

When to Use

Filter imported CSV or Google Sheets rows to only process relevant records
Remove invalid or incomplete entries before sending to downstream steps
Narrow down a large dataset to a subset matching specific criteria
Apply business rules to select which items proceed in the workflow

How It Works

The Filter Rows action reads an array from its input slot and applies the configured filter conditions. Elements that match the conditions are included in the output list array; elements that don't match are excluded. The output also includes a list_count of the remaining elements. The output field set is locked.

Actions

Filter Rows

Filter array elements by condition

How it works

Reads an array from the input field set and applies filter conditions. Matching rows are included in the output; non-matching rows are excluded. Outputs {list: [...], list_count: N} with the filtered subset. The output field set is locked.

Place between an import/Collect step and a For Each step to filter before iterating
Combine multiple conditions for complex filtering logic

Tips

Filter is most useful between data source steps (Import, Collect) and processing steps (For Each)
The output shape (list + list_count) is compatible with For Each and export steps
Use filter to reduce iteration count before a For Each loop for better performance

Related Steps

Step Guide: For Each

Iterate over array elements

Step Guide: CSV

2 actions

Import or export CSV files

Step Guide: Google Sheets

5 actions

Import, export, or read a single row from Google Sheets

Step Guide: Collect

Gather iteration results into an array