Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places. Read all previous how-to guides.
On to the question.
How to delete multiple table rows?
A Workflows table provides fast-short term storage for flows. Check out Workflows Tips #20: How to Manage Tables for Fast Short-Term Storage to learn when to use tables.
In this guide you will learn how to delete multiple rows.
You have a table that holds positive and negative numbers. You want to delete all rows with a negative number.
The solution has two flows:
- A flow to find all rows to delete (with negative numbers)
- A helper flow to delete each row
The main flow searches for rows with negative numbers and passes each row to a helper flow for deletion:
The flow has the following cards:
- Tables – Search Rows finds all the rows with negative numbers
- A list of rows with negative numbers is passed to List – For Each. For Each calls a helper flow ([Helper] Delete row) for each item passing its Row ID
The Tables – Search Rows option view:
Search criteria (to change it click on Change link – see above screenshot):
To pass a row ID to the helper flow, click the down arrow for Row ID field and choose Item > Row ID:
The helper flow deletes each row by itself Row ID:
After the flow is run all rows with negative numbers are deleted:
In this short how-to guide you learned how to delete multiple table rows.