StéphaneL.00832 (Customer) asked a question.
Workflows - TABLES search Rows limit = 3.5K
Hi Guys,
I would like to clear an Okta table of 10K rows. I followed this link "https://support.okta.com/help/s/article/Okta-Workflows-How-to-clear-a-table-in-Workflows" but unfortunately I cannot clear more than 3.5k rows. That limit of 3.5K max for Search Rows has been confirmed by Okta support.
(Previous limit was 1,000 - OKTA-345995: The Search Rows function card only read the first 1,000 rows of a table. https://help.okta.com/en/prod/Content/Topics/Settings/Version_Histories/Ver_History_Workflows.htm)
How could I clear a whole table of more than 3.5K rows ?
Ok, I figured out a way to achieve that :
1- Parent flow : Flow control "Repeat" x time Child flow_1
2- Child flow_1 : Search Rows (First matching row) + Continue If + Search Rows (All matching rows + For Each
3- Child flow_2: Delete Rows
It works like a charm 🙂