Two arrays of users - Is it possible to remove users who appear in both?

[mikraphne]

So, I have a Logic App that I have that is pulling a large list of users from the MS Graph API. One array is filled with all of the users in our environment. The other array is filled with users of a specific group. Both arrays have displayName contained in them, so I was hoping that there was a way to make it so that I can remove all users who are in the group array, so I am just left with a list of users not in the group?

I had hoped that the MS Graph API allowed you to use filter=not memberOf or something like that, but it seems this is somehow not possible. I am new to logic apps and MS Graph, so this might have better ways to be accomplished, but I was hoping to figure out more on the filtering capabilities within Power Automate.

[ManishSolanki · Accepted solution]

Hi @mikraphne 

Here is the sample flow.

I have used 2 compose action for storing the array object of each group and name those compose actions as 'Group1' & 'Group2'. For this example, I have used only one property 'displayName' to demonstrate the steps for filtering the arrays.

[
{
"displayName": "Manish"
},
{
"displayName": "Thomas"
},
{
"displayName": "Sudeep"
},
{
"displayName": "Dennis"
}
]

[
{
"displayName": "Arun"
},
{
"displayName": "Thomas"
},
{
"displayName": "Sudeep"
},
{
"displayName": "Dennis"
}
]

To find the users of group1 who are not member of group2, we will first add "Select" action to collect the displayName of users in group2 as a string array. Pass the Group2 array to the 'From' parameter:

Next, click 'Switch Map text mode' button:

Enter the expression in the expression box as shown below:

item()?['displayName']

Finally, add "Filter array" action to get the array of users from Group1 who are not the members of Group2. Pass the Group1 array to the 'From' parameter:

Click 'Edit in advanced mode' button on the bottom of this action and enter the below query:

@not(contains(body('Select'), item()?['displayName']))

The output body of the filter array will give the desired array.

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.