Okta Workflows Search Rows Card Does Not Pick Up True/False Values
Last Updated:
Overview
The Search Rows card in Okta Workflows fails to return table rows when filtering on a column value of True or False.
Applies To
- Workflows
Cause
When an existing Workflows table is updated with a new column that uses True/False and a default value, rows created before the default value was correctly applied may contain null values in the column instead of explicit True or False. Although the user interface may display True or False, the column stores null on the backend for those rows. This discrepancy causes the Search Rows card to return empty results.
Solution
Perform the following steps to ensure the Boolean column values are correctly populated in the table:
-
Export the table data to a Comma Separated Values (CSV) file.
-
The True/False rows will appear blank in the file.
-
-
Clear the table in Workflows.
-
Re-import the data from the CSV file.
-
This action correctly populates the True/False column with its default value for all rows.
-
-
Re-run the flow and verify that the Search Rows card returns the expected results.
