Overview

This article will teach you how to search for users using custom criteria and save them to a table.

Solution

The automation has two flows:

1. List users: Clears the table, then searches for users.
2. Save user to table: The helper flow receives each user and saves it as a row in the table.

Search users

This flow searches for users.

Search for users using custom criteria.

How the flow works

1. Tables – Clear Table clears all existing rows from the table.
2. Okta – List Users with Search searches for users matching the status (Deactivated) and custom search criteria. The custom criteria uses the co (contains) operator to check for the email domain. Each matching user is streamed to the helper flow.

Save user

This flow saves users to a table.

Save a user to a table.

How the helper flow works

1. The Helper Flow card receives a user record object with all user fields and reads the Email and ID fields.
2. The Tables – Create Row card saves the user ID and email as a new row in the table.

Deactivated users table

The table holds deactivated users.

Deactivated users table.

Related References

• Search for Users Using Contains in Okta Workflows
• Search for Users using Custom Search Criteria in Okta Workflows
• How to List Users Assigned to an Application and Save Users to a Table