Get a liste of all site members without the site owners

(0) Share

Report

Posted on by Bügelperle

Hi All,

I'm trying to figure out how to get a list of all members of a given sharepoint site without the actual site owners.

I was able to get the owners and members using the graph-API http requests.

https://graph.microsoft.com/v1.0/groups/{group-ID}/owners

https://graph.microsoft.com/v1.0/groups/{group-ID}/members

Result

Owner: John, Grant

Member: John, Claudia, Paul, Grant, Andrea

I'd like to remove John and Grant from the members list

Any ideas how to do this?

Cheers,
Bügelperle

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @Bügelperle ,

Please refer to below steps:
1. I compose your Owner/Member as test data, and initialize a variable to store the result later.
2. Split "Member" and make comparison with "Owner". If it's contained in "Owner", no action will be taken. If not, append the object to variable.
3. Finally we will use below function to delete extra comma and blank space.
take(variables('vartest'),sub(length(variables('vartest')),2))
Here's the result:

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,183 Most Valuable Professional on at

Like (1)

Report
Hi @Bügelperle,

An alternative approach could be to use the two arrays and filter them using a Filter Array action. @DamoBird365 has blog about this Except approach:

https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

Below is an example for this scenario.

1. The Filter array uses the below expression in the From:

outputs('Send_an_HTTP_request_-_Members')?['body']['value']

2. And the below criteria is used (in advanced mode)

@not(contains(outputs('Send_an_HTTP_request_-_Owners')?['body']['value'], item()))

Was this reply helpful? Yes No
Bügelperle 5 on at

Like (0)

Report

@Expiscornovus & @v-wenjuan-msft thanks for your support. You guys helped me a lot.

Was this reply helpful? Yes No