
JoshuaS.52230 (Customer) asked a question.
Looking for helping developing this flow. There is a table A of groups and the users in the groups. There is a separate table B with groups and multiple applications assigned to these groups. The groups are the same in both tables.
What i'm trying to do is look up the group in table A, get the users assigned to the group, then look up the same group in table B and the apps assigned to that group. Then assign those users in that group to each of the applications assigned to that group.
Struggling to figure out the best way to do this. I've conceptualized a few ways but they are way too complicated. Suggestions appreciated.

Hello @JoshuaS.52230 (Customer) Thank you for posting on our Community page!
If I understood correctly, users that part of groups from Table A will also be part of groups from Table B, where groups from Table B will have applications assigned to them.
If the above is correct, you can use Group Rules In Okta where if a user is part of group 1 (from Table A) will also be added to group a (from Table B) then you can assign a specific or more applications to group a.
With this flow, you will just need to add the user to group 1 and they will be automatically added to group a with the respective application.
For group rules, you can review our doc below:
https://help.okta.com/oie/en-us/content/topics/users-groups-profiles/usgp-create-group-rules.htm
Thank you for reaching out to our Community and have a great day!
--
Join the discussion for the Ask Me Anything online event on May 23, 2024 with Okta Tactical Edge Product Experts
Thank you for the reply. Unfortunately my wording was confusing. The "groups" in table A are not in Okta but rather an arbitrary grouping of users in the table.