
SarahS.89561 (Customer) asked a question.
I want to be able to write a users groups to a table and then search the table for a specific group ID, I then want to continue if the users is in the relevant group, I then want to clear the table of all values for that user
As per usual, any help would be appreciated

Hi Sarah,
Based on your description the "first" use case (write out all of a user's groups to a table) would require a total of 2 flows + 1 table.
The table would contain the pertinent columns for the data you want to retain.
The first flow would be the Okta Card - Get Users Groups which you would Stream to a Helper flow (The Helper would have a minimum State & Record defined)
In the Helper flow you pull the needed data from State & Record to be utilized in an "Create Row" card to update the table.
At this point you would have a table created and updated with all of the user's groups. The next part really depends on the use case. For example if you then immediately want to check for the group you would then add a "Search Rows" to the Parent (first flow) after the Get Users Groups card. It would then search for the group. If found do your next logic. Then at the end of the flow clear the rows in the table.
Hi Tim
Thanks for that, can I expand a bit, as before I would like to write the users groups to a table, search for a specific group and then continue if found, I would then like to look in the table for that user and see if they are a member of a group that starts with "pattern" eg. swi_, If that value exists, I would like to contiue and take that group name foward for later use in the flow and at the end, clear the table of any rows for that user
Hope that makes sense, I'm struggling in how to do the continue if first group found as can't drop a list on a continue if
Kind regards
Sarah
Okay, so if you are just wanting to evaluate IF something in the list contains a specific partial string before continuing on with the flow and the source is a table result the following should work: