Okta Workflows How-To: Delete Multiple Table Rows

Okta Workflows is a no-code platform for automating identity processes. 

This blog post is based on a question asked during office hours or the #okta-workflows channel in MacAdmins Slack: How to Delete Multiple Table Rows?

Getting started

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_hoto_table_delete_rows.png (1136×944)
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:

workfflows_howto_table_delete_rows_flow1a.png (1030×1144)
Searching table rows

The flow has the following cards:

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

workflows_howto_table_delete_options-1.png (498×760)
Search Rows options

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

workflow_howto_table_delete_search_criteria.png (1112×832)
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:

workflows_howto_table_delete_helper_input.png (686×982)
Setting helper flow input

The helper flow deletes each row by its Row ID:

workflows_howto_table_delete_rows_helper.png (1070×766)
Delete a table row

The flow will delete rows with negative numbers:

workflows_howto_table_delete_after_delete.png (1118×590)
After deleting rows with negative numbers

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

Get your Workflows questions answered

Do you have a question about Okta Workflows? Not sure how to build a flow? Join the weekly community office hours to get help.