Flow designer remove user action not working

Burhan2
Tera Contributor

I have a flow where reqfor user should be automatically removed from group when requested. We have a list collector group field and when submitted reqfor user should be removed from the mentioned groups in that field . I created action for that but it seems deleteRecord() method is not working in flow...the script was working fine in workflow and user was getting removed.. I have also automation to Adduser and that is working correctly can nyone help me in this

Attaching script for removal from action.:-group.pngremove.png

(function execute(inputs, outputs) {
var req_for = inputs.Reqfor;
var team = inputs.Grouplist.toString().split(',');
var addorremove=inputs.AddorRemove;
if (addorremove == 'Add') {
    for (var i = 0; i < team.length; i++) {

        var grpMembr = new GlideRecord('sys_user_grmember');
        grpMembr.addQuery('group', team[i]);
        grpMembr.addQuery('user', "!=", req_for);
        grpMembr.query();
        while (grpMembr.next()) {
            grpMembr.initialize();
            grpMembr.group = team[i];
            grpMembr.user = req_for;
            grpMembr.insert();
        }

    }
}
else if (addorremove == 'Remove') {
   
        for (var i = 0; i < team.length; i++) {

        var grpMembr = new GlideRecord('sys_user_grmember');
        grpMembr.addQuery('group', team[i]);
        grpMembr.addQuery('user', "=", req_for);
        grpMembr.query();
        while (grpMembr.next()) {
        grpMembr.deleteRecord();
        }

   
}

    }


})(inputs, outputs);
1 ACCEPTED SOLUTION

@Burhan2 

Below is the working solution, user was part of 2 groups and flow ran and removed that user from those groups

flow remove user from group.gifflow remove user from group 1.gif

I believe I have provided enough guidance and responded to all your questions.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

33 REPLIES 33

@Burhan2 

I could see the Reqfor is not a sysId and hence it's not working

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Burhan2 

what input you are passing to Reqfor?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

reqfor i am passing reference.user and for Adduser its working so same reqfor is used for that also...then why only for removal its not working?? Also i did a test in action and removal is working but through flow only its not working even though u can check i am getting all values in flow context as well @Ankur Bawiskar 

@Burhan2 

Are you sure your flow action is configured to Run as System?

what's the error when you are trying to delete?

May be your action is not configured to Run as System and some ACL is blocking the delete operation

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

There is no error when removal is performed it always gets completed and success....i don't see any option in action to set it run as system as we do in flow? @Ankur Bawiskar