Flow.Documentation
Professional

Process row by row with a loop

7 steps± 5 minVideoVerified 22 Oct 2026
  1. Step 1 · Open your development environment
  2. Step 2 · Read the orders
  3. Step 3 · Add a loop
  4. Step 4 · Calculate per order
  5. Step 5 · Write every result to the second table
  6. Step 6 · Run
  7. Step 7 · Look at the second table

A workflow reads the orders from a table, calculates the amount including VAT per order and writes it to a second table. That is how you learn the Loop (for each): steps that repeat per item, with variables you name yourself.

Watch the whole guide as a video7 steps in one film
Step 1 / 7

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 / 7

Read the orders

Create a new workflow and add the Table step. Choose the orders table; the step looks up the rows and passes them on as the list rows.

  1. Click Add to General
Read the orders · Click Add to General
  1. Click New workflow
Read the orders · Click New workflow
  1. In Workflow name, type Calculate VAT
Read the orders · In Workflow name, type Calculate VAT
  1. Click Add node
Read the orders · Click Add node
  1. Click Table
Read the orders · Click Table
  1. In Table, choose Orders week 41 · 3
Read the orders · In Table, choose Orders week 41 · 3
  1. Click the dot of ‘Event trigger’
Read the orders · Click the dot of ‘Event trigger’
  1. Click the dot of ‘Orders week 41’
Read the orders · Click the dot of ‘Orders week 41’
Step 3 / 7

Add a loop

Everything inside the loop's area is repeated, for every item in the list. Choose rows as the list and call the current item bestelling (order). Inside the loop that is {{bestelling}}; afterwards it is gone again.

  1. Click Loop
Add a loop · Click Loop
  1. In Which list do you want to process? The list comes from the previous node., type rows
  2. In Name of the current item Steps read the item as {{bestelling.naam}}., type bestelling
Add a loop · In Which list do you want to process? The list comes from the previous node., type rows; In Name of the current item Steps read the item as {{bestelling.naam}}., type bestelling
  1. Click the dot of ‘Orders week 41’
Add a loop · Click the dot of ‘Orders week 41’
  1. Click the dot of ‘Loop’
Add a loop · Click the dot of ‘Loop’
Step 4 / 7

Calculate per order

In the loop choose Add step → Transform data. Remove the example fields and create a field incl. A value starting with = is a calculation: = round(bestelling.bedrag * 1.21, 2).

  1. In Transform data, choose Transform data
Calculate per order · In Transform data, choose Transform data
  1. Click Remove field
Calculate per order · Click Remove field
  1. Click Remove field
Calculate per order · Click Remove field
  1. In New field, type incl
  2. In incl, type = round(bestelling.bedrag * 1.21, 2)
Calculate per order · In New field, type incl; In incl, type = round(bestelling.bedrag * 1.21, 2)
Step 5 / 7

Write every result to the second table

Add another Table step inside the loop, choose the second table and Add one row. Per column you say what goes in: the customer from the order, and the amount you just calculated. Connect the two steps in the loop.

  1. In Table, choose Table
  2. In Table, choose Orders incl. VAT · 0
  3. In What does this step do? Look up rows Get one row (by id) Add one row Add rows fr, choose Add one row
  4. In klant * text, type {{bestelling.klant}}
  5. In bedrag_incl * number, type {{incl}}
Write every result to the second table · In Table, choose Table; In Table, choose Orders incl. VAT · 0; In What does this step do? Look up rows Get one row (by id) Add one row Add rows fr, choose Add one row; In klant * text, type {{bestelling.klant}}; In bedrag_incl * number, type {{incl}}
  1. Click the dot of ‘Transform data’
Write every result to the second table · Click the dot of ‘Transform data’
  1. Click the dot of ‘Orders incl. VAT’
Write every result to the second table · Click the dot of ‘Orders incl. VAT’
Step 6 / 7

Run

At the bottom you see every pass with the item whose turn it was, and at the end how often the loop ran. What each pass changed is in loop.results after the loop.

  1. Click Save
Run · Click Save
  1. Click Run
Run · Click Run
Run · Three passes: one per order.
Step 7 / 7

Look at the second table

Open the second table: there is a row per order, with the amount including VAT.

  1. Click the second table
Look at the second table · Click the second table
Look at the second table · Three rows, written by the workflow.
Look at the second table · 450 becomes 544.50 including VAT.

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