DEV Community

Max Katz for Okta Workflows

Posted on • Originally published at maxkatz.net on

How to Delete Multiple Table Rows

Okta Workflows how-to guides are questions and answers from weekly community office hours, MacAdmins Workflows Slack channel, and other places.

Read all the other 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.

Workflows table

Workflows table

The solution has two flows:

  1. A flow to find all rows to delete (with negative numbers)
  2. 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:

Searching table rows

Searching table rows

The flow has the following cards:

  • Tables – Search Rows finds all the rows with negative numbers
  • A list of rows with negative number 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 options view:

Search Rows options

Search Rows options

Search criteria (to change it click on Change link – see above screenshot):

Searching table criteria

Searching table criteria

To pass a row ID to the helper flow, click the down arrow for Row ID field and choose Item > Row ID :

Setting helper flow input

Setting helper flow input

The helper flow deletes each row by its Row ID :

Delete a table row

Delete a table row

After the flow is run all rows with negative numbers are deleted:

After deleting rows with negative numbers

After deleting rows with negative numbers

In this short how-to guide you learned how to delete multiple table rows.


📺 Short how-to Workflows videos to help you become a better automation builder.

🍭 A collection of helpful Workflows tips.

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More