How to Search for Users with Custom Criteria and Save Results to a Table in Okta Workflows

In this guide:

Okta Workflows guides

Okta Workflows guides offer questions and answers from the Okta Workflows community office hours. They also come from the #okta-workflows channel on the Mac Admins Slack and other places. Read all the other guides.

How to search for users with custom criteria and save results to a table in Okta Workflows?

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

The automation has two flows:

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

This flow searches for users.

Tables – Clear Table clears all existing rows from the table.
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.

This flow saves users to a table.

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

The table holds deactivated users.

🚀 New to Okta Workflows? The Getting Started with Okta Workflows page has all the resources to help you get started.
📺 Like learning from videos? Watch Okta Workflows videos.
❓Have a question? Ask during community office hours or post on the community forum.
💬 Want to learn from the community? Join the #okta-workflows channel on the Mac Admins Slack.
🎓 Want to learn more about identity automation? Take the Okta Workflows training on Okta Learning.