Flow.Documentation
ProfessionalWorkflows

Table: update a row

5 steps± 4 minVideoVerified 22 Oct 2026
  1. Step 1 · Open Flow and create a workflow
  2. Step 2 · Look the row up
  3. Step 3 · Update the row you found
  4. Step 4 · Put the steps in one line and save
  5. Step 5 · Run and look in the table

Updating a row always goes by id: that way Flow knows for sure which row you mean. Usually you do not know the id, but you do know something else, such as an invoice number. Then you look the row up first and update the row you found. Here you mark an invoice as paid.

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

Look the row up

The request names the invoice number. Put it in the sample data. Add the Table step with Look up rows, a condition number = {{number}}, and call the result invoices.

  1. Click the step ‘Event trigger’
Look the row up · Click the step ‘Event trigger’
  1. Click Code
Look the row up · Click Code
  1. In the sample data, type `{
Look the row up · In the sample data, type `{; ;
  1. Click Add node
Look the row up · Click Add node
  1. Click Table
Look the row up · Click Table
  1. In Name, type Find the invoice
  2. In Table, choose Guide · invoices · 2
Look the row up · In Name, type Find the invoice; In Table, choose Guide · invoices · 2
  1. Click ＋ Condition
Look the row up · Click ＋ Condition
  1. In value, type {{number}}
  2. In Store the result as Next steps read this as {{invoices}}., type invoices
Look the row up · In value, type {{number}}; In Store the result as Next steps read this as {{invoices}}., type invoices
  1. Click the dot of ‘Event trigger’
Look the row up · Click the dot of ‘Event trigger’
  1. Click the dot of ‘Find the invoice’
Look the row up · Click the dot of ‘Find the invoice’
Step 3 / 5

Update the row you found

Add another Table step, on the same table, and choose Update a row (by id). Under Row id you read the id of the first row found: {{invoices.0.id}} (counting starts at 0). Fill in only the column that changes.

  1. Click Add node
Update the row you found · Click Add node
  1. Click Table
Update the row you found · Click Table
  1. In Name, type Mark as paid
  2. In Table, choose Guide · invoices · 2
  3. In What does this step do? Look up rows Get one row (by id) Add one row Add rows fr, choose Update a row (by id)
  4. In Row id, type {{invoices.0.id}}
  5. In status, type paid
Update the row you found · In Name, type Mark as paid; In Table, choose Guide · invoices · 2; In What does this step do? Look up rows Get one row (by id) Add one row Add rows fr, choose Update a row (by id); In Row id, type {{invoices.0.id}}; In status, type paid
  1. Click the dot of ‘Find the invoice’
Update the row you found · Click the dot of ‘Find the invoice’
  1. Click the dot of ‘Mark as paid’
Update the row you found · Click the dot of ‘Mark as paid’
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 ‘Find the invoice’ while holding Shift
Put the steps in one line and save · Click ‘Find the invoice’ while holding Shift
  1. Click ‘Mark as paid’ while holding Shift
Put the steps in one line and save · Click ‘Mark as paid’ 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 and look in the table

The first step found the invoice, the second updated it. In the table F-1001 is now paid; F-1002 was not touched.

  1. Click Run
Run and look in the table · Click Run
Run and look in the table · Status: Completed.
Run and look in the table · Row updated.
  1. Click the table
Run and look in the table · Click the table
Run and look in the table · F-1001 is marked as paid.

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