Flow Designer -- Removing inactive users from groups/roles

[Alex Edmiston1]

I'm looking to use flow designer to remove users whose state changes from true from assignment groups and remove their system roles... has anyone done this before/know what table you would use for the action?

[uwnewbie]

Hi,

we now run the flow under my admin account, however this will cause an issue once I leave the company 😉 

Here is the response we got, when we contacted HI Portal:

I believe as per security rules, the delete on sys_user_group is available only for Admin users.

Also, the "can delete" application access is not checked which will enforce the restriction on other application scopes to delete records from this table. This option offers runtime protection.

[Biji]

I have created an action in the flow to impersonate as system admin and then the update/delete worked successfully

[Biji]

impersonating as admin will work some times.. I do not know why

[Community Alums]

I'd just like to say thanks for this one, I have taken the flow above and amended to meet our business requirements. 
I have the flow create a Task to record every time this flow runs and the output.

I also get the same issue as `uwnewbie` but for the time being running as system is not critical for us.

 

[uwnewbie]

Hi,

this is interesting. Did you create a standalone Task or did you connect it to a request or so?

The system architect of my company would not allow me to create standalone Tasks, so I only document the user cleanup by writing the details into the log.