Flow.Documentation
ProfessionalWorkflows

In-memory table and Add row

7 steps± 5 minVideoVerified 22 Oct 2026
  1. Step 1 · Open Flow and create a workflow
  2. Step 2 · A list to start from
  3. Step 3 · Set the columns
  4. Step 4 · Fill it from the list
  5. Step 5 · Add a row to it
  6. Step 6 · Put the steps in one line and save
  7. Step 7 · Run

An In-memory table exists only during the run. You give it fixed columns with a type, fill it from a list and get clean JSON back: every row is checked, so text in a number column stands out straight away. With Add row you then add single rows. Handy for an answer to a caller or an export.

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

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 · invoice lines
Open Flow and create a workflow · In Workflow name, type Guide · invoice lines
Step 2 / 7

A list to start from

Put an order with lines in the trigger's sample data.

  1. Click the step ‘Event trigger’
A list to start from · Click the step ‘Event trigger’
  1. Click Code
A list to start from · Click Code
  1. In the sample data, type `{
A list to start from · In the sample data, type `{; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;
Step 3 / 7

Set the columns

Add In-memory table. Under Columns you give every column a name and a type; ＋ Column adds one. Here: article (text, required) and amount (number).

  1. Click Add node
Set the columns · Click Add node
  1. Click In-memory table
Set the columns · Click In-memory table
  1. In Name, type Invoice lines
  2. In column 1, type article
Set the columns · In Name, type Invoice lines; In column 1, type article
  1. Click ＋ Column
Set the columns · Click ＋ Column
  1. In column 2, type amount
  2. In type of column 2, choose Number
Set the columns · In column 2, type amount; In type of column 2, choose Number
  1. Click the dot of ‘Event trigger’
Set the columns · Click the dot of ‘Event trigger’
  1. Click the dot of ‘Invoice lines’
Set the columns · Click the dot of ‘Invoice lines’
Step 4 / 7

Fill it from the list

Under From which list you type lines. Per column you say what goes in, with {{item.…}} for the item whose turn it is; amount is a calculation: = item.quantity * item.price. The result is called rows.

  1. In From which list? Path to a list, for example items or loop.results., type lines
  2. In article * text, type {{item.article}}
  3. In amount number, type = item.quantity * item.price
Fill it from the list · In From which list? Path to a list, for example items or loop.results., type lines; In article * text, type {{item.article}}; In amount number, type = item.quantity * item.price
Fill it from the list · Store the result as: empty, so rows.
Step 5 / 7

Add a row to it

Add Add row; under Which in-memory table is rows. Fill in the columns for one extra line: the shipping costs.

  1. Click Add node
Add a row to it · Click Add node
  1. Click Add row
Add a row to it · Click Add row
  1. In Name, type Shipping
Add a row to it · In Name, type Shipping
Add a row to it · The table rows.
  1. In article * text, type Shipping
  2. In amount number, type = 6.95
Add a row to it · In article * text, type Shipping; In amount number, type = 6.95
  1. Click the dot of ‘Invoice lines’
Add a row to it · Click the dot of ‘Invoice lines’
  1. Click the dot of ‘Shipping’
Add a row to it · Click the dot of ‘Shipping’
Step 6 / 7

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 ‘Invoice lines’ while holding Shift
Put the steps in one line and save · Click ‘Invoice lines’ while holding Shift
  1. Click ‘Shipping’ while holding Shift
Put the steps in one line and save · Click ‘Shipping’ 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 7 / 7

Run

The table got three rows from the list and then one single row on top. Under Data after the run is rows: only the columns you set, with numbers as numbers.

  1. Click Run
Run · Click Run
Run · Status: Completed.
Run · Three rows from the list.
Run · And the fourth added.
Run · The Shipping line in rows.

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