Remove User from Assignment Group with Flow Designer

[Gabriel Ho]

Hi, I`m looking for an "Flow Designer" flow to remove ITIL User from her Assignment Groups.

I dont want to delete the Group, I only want an automatic flow, who can remove the selected Groups from the User Groups (selected in Catalog Item).

Have anyone an Idea?

I know, that I can use the table sys_user_grmembers

[Gabriel Ho]

Here is my script include for the refrence qulifier: 

function refqualgroupmemebers(){

var group = current.variables.assignment_group; // your assignment_group variable name
var users = '';
if(group!=''){
var getMembers = new GlideRecord('sys_user_grmember');
getMembers.addQuery('group',group);
getMembers.query();
while(getMembers.next())
{
users = users + ','+ getMembers.user;
}
return 'sys_idIN' + users;
}
else{
return 'active=true';
}
}

[Pedram Haghzab1]

Hello,

I'm actually trying to do the same thing. Would you please elaborate the flow process? I'm new to flow designer and not sure how to create the trigger action. Also, I understand that the question for the group you have created is by variable set, but how did you manage to filter the members by the group selected?

[Ed Hefford]

Hi @Pedram Haghzaban  @Gabriel Ho 

variable on the multi row variable set is very simple, one line works for me.

assignment_group is a lookup select box based on the group field.

assignment_user is a reference with the qualifer of "javascript:u_getMembers(current.variables.assignment_group);"

Thats it!

[Pedram Haghzab1]

Hello,

Thanks for the reply.

Is this what you meant for user:



And this for group:



If so, I ran into this issue where it shows lots of duplicates for assignment group. Still shows all the users. So it looks like I'm making a mistake somewhere.

The other issue I ran into is with the flow steps. I tried to replicate your image, but wasn't sure on little details on each action.

Here is what I have:

I tried requested item record pill but whenever I try to save it, it loops for ever and never finishes



For each:



Delete Record:

Update Record:




Thanks

[Ed Hefford]

Hi @Pedram Haghzaban , if you click on the checkboxes for your assignment group variable to show the following, this will remove the duplicates. For each entry within the groups table, you'll have a record. Checking the unique values only reduces the results to 1.

With regards to your flow for Get Catalog Variables, you need to select the trigger record as Submitted Request Item where you field is mandatory.

For the final step 7, I update the RITM by setting the below values