This guide teaches how to suspend multiple users from a CSV file.

• Okta Workflows

The automation has two flows:

1. Getting users to suspend.
2. Pass each user to a helper flow to suspend the user.

1. Getting users flow

The main flow to get users to suspend:

This flow has the following steps:

1. 1. Google Drive – Download File card.
   2. This Download File card downloads the CSV file with users to suspend. This is how the CSV file looks:

1. 3. Tables – Import from CSV card

Using the Import from CSV card, the flow imports users from the CSV into a Workflows table to process each user. The table looks like this:

1. 4. Table – Search Rows card

The Search Rows card returns all the users in a table and passes them to a List – For Each card for processing.

1. 5. List – For Each card

The For Each card calls a helper flow for each user in the list and passes the User ID to the helper flow.

1. 6. Tables – Clear Table card

The Clear Table card clears the table after the helper flow suspends all the users. With a clear table, the main flow is ready to run again.
 

2. Suspend a user flow

This helper flow suspends a user.

The helper flow has the following steps:

1. 1. On-Demand – Helper Flow card

The Helper Flow card defines User ID input for the helper flow. It passes the User ID to the next card, Okta – Suspend User.

1. 2. Okta – Suspend User card

The Suspend User card suspends the user.
 

Related References

• How to Setup a Workflows Helper Flow (with For-Each and Streaming Cards)
• How to Iterate Over Rows in a Table in Okta Workflows