Flow.Documentation
ProfessionalTables

Search and filter in a table

5 steps± 4 minVideoVerified 22 Oct 2026
  1. Step 1 · Open your development environment
  2. Step 2 · A workflow with the Table step
  3. Step 3 · A condition: equals
  4. Step 4 · More than equals
  5. Step 5 · Run

With the Table step a workflow fetches exactly the rows it needs. With Only rows where… you set conditions that must be equal; for ‘contains’, ‘at least’, ‘one of’ and ‘not’ you use the advanced configuration. In a bike shop's customer questions you look for the open questions about brakes from 50 euros.

Watch the whole guide as a video5 steps in one film
Step 1 / 5

Open your development environment

In the portal, under Environments, click Development, and there Open. Flow opens in a new tab and you are signed in straight away.

  1. Click Development
Open your development environment · Click Development
  1. Click Open ↗
Open your development environment · Click Open ↗
Step 2 / 5

A workflow with the Table step

Create a new workflow, name it and add the Table step from the library. Choose the table; the operation is already set to Find rows. Connect the trigger to the step.

  1. Click Add to General
A workflow with the Table step · Click Add to General
  1. Click New workflow
A workflow with the Table step · Click New workflow
  1. In Workflow name, type Find open brake questions
A workflow with the Table step · In Workflow name, type Find open brake questions
  1. Click Add node
A workflow with the Table step · Click Add node
  1. Click Table
A workflow with the Table step · Click Table
  1. In Table, choose Customer questions · 5
A workflow with the Table step · In Table, choose Customer questions · 5
  1. Click the dot of ‘Event trigger’
A workflow with the Table step · Click the dot of ‘Event trigger’
  1. Click the dot of ‘Customer questions’
A workflow with the Table step · Click the dot of ‘Customer questions’
Step 3 / 5

A condition: equals

Under Only rows where… click ＋ Condition, choose the column and type the value. Only rows with exactly that value come along. The value may also be a variable, such as {{request.stage}}.

  1. Click ＋ Condition
A condition: equals · Click ＋ Condition
  1. In the column, choose stage
  2. In the value, type open
A condition: equals · In the column, choose stage; In the value, type open
A condition: equals · stage = open
Step 4 / 5

More than equals

Open Advanced configuration and choose Code. Under filter, a column can get a condition instead of a value: contains (case does not matter), gte and lte (at least, at most), gt and lt (greater, less), in (one of a list) and not (anything but). Here: the subject contains brake and the amount is at least 50.

  1. Click ▸ Advanced configuration
More than equals · Click ▸ Advanced configuration
  1. Click Code
More than equals · Click Code
  1. In the configuration, type `{
More than equals · In the configuration, type `{; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
Step 5 / 5

Run

Put the steps on one line (click a step, ⌘A, Align horizontally), save and run. At the bottom you see how many rows were found; the rows themselves are in rows, ready for the next step, for example a loop.

  1. Click the step ‘Customer questions’
Run · Click the step ‘Customer questions’
  1. Click Align horizontally
Run · Click Align horizontally
  1. Click Save
Run · Click Save
  1. Click Run
Run · Click Run
Run · 2 of 2 rows from Customer questions: the brake questions of 65 and 180 euros; the closed one and the one of 25 euros drop out.

This guide was carried out step by step on 22 Oct 2026 by an automated test on Flow (version 3e563176).