How to Delete Multiple Table Rows
Tags: nocode, workflows, tutorial, ipaas
Published: 2022-09-01 17:47:43

---
title: How to Delete Multiple Table Rows
published: true
date: 2022-09-01 05:05:06 UTC
tags: NoCode,Workflows,  tutorial, ipaas
canonical_url: https://maxkatz.net/2022/07/19/how-to-delete-multiple-table-rows/
---

[Okta Workflows](https://www.okta.com/platform/workflows/) how-to guides are questions and answers from weekly community [office hours](https://calendly.com/oktaworkflows/group-office-hours-okta-workflows), MacAdmins [Workflows Slack channel](https://www.macadmins.org/), and other places. 

Read all the other how-to guides ⤵️
{% embed https://dev.to/oktaworkflows/all-okta-workflows-how-to-guides-4nl9 %}

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](https://dev.to/maxkatz/workflows-tips-20-how-to-manage-tables-for-fast-short-term-storage-44lp-temp-slug-5465619) 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](https://katzmax.files.wordpress.com/2022/07/workflows_hoto_table_delete_rows.png?w=1024)](https://katzmax.files.wordpress.com/2022/07/workflows_hoto_table_delete_rows.png)
<figcaption>Workflows table</figcaption>

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](https://katzmax.files.wordpress.com/2022/07/workfflows_howto_table_delete_rows_flow1a.png?w=922)](https://katzmax.files.wordpress.com/2022/07/workfflows_howto_table_delete_rows_flow1a.png)
<figcaption>Searching table rows</figcaption>

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](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_options-1.png?w=498)](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_options-1.png)
<figcaption>Search Rows options</figcaption>

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

[![Searching table criteria](https://katzmax.files.wordpress.com/2022/07/workflow_howto_table_delete_search_criteria.png?w=782)](https://katzmax.files.wordpress.com/2022/07/workflow_howto_table_delete_search_criteria.png)
<figcaption>Searching table criteria</figcaption>

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](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_helper_input.png?w=686)](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_helper_input.png)
<figcaption>Setting helper flow input</figcaption>

The helper flow deletes each row by its **Row ID** :

[![Delete a table row](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_rows_helper.png?w=1024)](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_rows_helper.png)
<figcaption>Delete a table row</figcaption>

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

[![After deleting rows with negative numbers](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_after_delete.png?w=1024)](https://katzmax.files.wordpress.com/2022/07/workflows_howto_table_delete_after_delete.png)
<figcaption>After deleting rows with negative numbers</figcaption>

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

* * *

📺 Short how-to [Workflows videos](https://youtube.com/playlist?list=PLIid085fSVdvyK8F4xuk49EchBPmAVNHG) to help you become a better automation builder.

🍭 A collection of helpful [Workflows tips](https://maxkatz.net/okta-workflows-tips/).