This guide will teach how to delete multiple table rows in Workflows.
- Okta Workflows
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.
A table contains both positive and negative numbers. The goal is to delete all rows containing 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:
- The Tables – Search Rows finds all the rows with negative numbers
- A list of rows with a negative number is passed to the List – For Each. For Each calls a helper flow ([Helper] Delete row) for each item, passing its Row ID
The Tables – Search Rows options view:
Search criteria (to change it, click on the Change link – see the above screenshot):
To pass a row ID to the helper flow, click the down arrow for the Row ID field and choose Item > Row ID:
The helper flow deletes each row by its Row ID:
After the flow is run, all rows with negative numbers are deleted:
