Flow.Documentation
BeginnerWorkflows

Table: look up rows

5 steps± 4 minVideoVerified 22 Oct 2026
  1. Step 1 · Open Flow and create a workflow
  2. Step 2 · Choose the table
  3. Step 3 · Only the rows you need
  4. Step 4 · Put the steps in one line and save
  5. Step 5 · Run

With the Table step a workflow works with the data in your Flow tables. Look up rows fetches the rows that meet your conditions, sorted the way you want, and passes them on as a list. A next step carries on with it: a loop per row, an answer to the caller, a message.

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

Open Flow and create a workflow

In the portal, under Environments, click Development and there Open; Flow opens in a new tab. There, click ＋ next to General, choose New workflow and give it a name. A new workflow starts with an Event trigger: the point where it begins.

  1. Click Development
Open Flow and create a workflow · Click Development
  1. Click Open ↗
Open Flow and create a workflow · Click Open ↗
  1. Click Add to General
Open Flow and create a workflow · Click Add to General
  1. Click New workflow
Open Flow and create a workflow · Click New workflow
  1. In Workflow name, type Guide · customers in Utrecht
Open Flow and create a workflow · In Workflow name, type Guide · customers in Utrecht
Step 2 / 5

Choose the table

Add the Table step and choose the table. After the name is how many rows it has. What does this step do is set to Look up rows: that is what you want here.

  1. Click Add node
Choose the table · Click Add node
  1. Click Table
Choose the table · Click Table
  1. In Table, choose Guide · customers · 4
Choose the table · In Table, choose Guide · customers · 4
  1. Click the dot of ‘Event trigger’
Choose the table · Click the dot of ‘Event trigger’
  1. Click the dot of ‘Guide · customers’
Choose the table · Click the dot of ‘Guide · customers’
Step 3 / 5

Only the rows you need

Under Only rows where… you add a condition: choose the column and fill in the value; it may also be a variable, such as {{city}} from the request. Sort by revenue, the largest first, and call the result customers.

  1. Click ＋ Condition
Only the rows you need · Click ＋ Condition
  1. In column, choose city
  2. In value, type Utrecht
  3. In **Sort by Newest first name · ascending name · descending city · ascending city · **, choose revenue · descending
  4. In Store the result as Next steps read this as {{customers}}., type customers
Only the rows you need · In column, choose city; In value, type Utrecht; In **Sort by Newest first name · ascending name · descending city · ascending city · **, choose revenue · descending; In Store the result as Next steps read this as {{customers}}., type customers
Step 4 / 5

Put the steps in one line and save

Select the steps (click the first, and the others while holding Shift) and click Align horizontally: they then stand in one line and you read the workflow from left to right; a branch (such as No of an If / Else) gets its own row below. Fit to view puts everything in sight; then Save.

  1. Click ‘Event trigger’
Put the steps in one line and save · Click ‘Event trigger’
  1. Click ‘Guide · customers’ while holding Shift
Put the steps in one line and save · Click ‘Guide · customers’ while holding Shift
  1. Click Align horizontally
Put the steps in one line and save · Click Align horizontally
  1. Click Fit to view
Put the steps in one line and save · Click Fit to view
  1. Click Save
Put the steps in one line and save · Click Save
Step 5 / 5

Run

At the bottom you see how many rows the step found: 2 of the 4, only those in Utrecht. Under Data after the run is the list customers, with the hotel at the top. Every row also has its id, for when you want to update it later.

  1. Click Run
Run · Click Run
Run · Status: Completed.
Run · 2 of 2 rows from the table.
Run · The hotel, with the largest revenue, first.

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