Graph API Request to Filter Active Members and Groups

Like (2) Share

Report

Posted on 22 Aug 2024 14:55:49 by David_MA

10,858 Super User 2025 Season 1

I need to make a call to the Graph API to get the members of a group with an active account and also return other groups within the group. I am using the following filter:

https://graph.microsoft.com/v1.0/groups/@{variables('Group ID')}/members?$count=true&$select=mail&$filter=endsWith(mail,'@mycompany.com') and accountEnabled eq true&$top=999

Note, the above query has ConsistencyLevel: eventual in the headers.
This works, but does not return any of the groups as it appears groups do not use the accountEnabled flag.
I searched the web and asked Copilot how to modify the query to include groups.
Copilot said to add or isOf('microsoft.graph.group') to the filter, but when I do it returns the error: "message": "Operator: 'IsOf' is not supported."
In this reference I cannot find anything related to filtering for groups: Advanced query capabilities on Microsoft Entra ID objects - Microsoft Graph | Microsoft Learn

Does anyone know how I can modify the query to include groups?

Thank you,

David

Categories:

Business Process Flows

All responses (2)

Answers (1)

Suggested answer

David_MA 10,858 Super User 2025 Season 1 on 23 Aug 2024 at 15:12:55

Like (2)

Report
Graph API Request to Filter Active Members and Groups

Thank you Expiscornovus. The link you provided helped. In the end, the only thing I needed to change to include the groups was to change the accountEnabled flag from equaling true to not equaling false.

https://graph.microsoft.com/v1.0/groups/@{variables('Group ID')}/members?$count=true&$select=mail&$filter=endsWith(mail,'@mycompany.com') and accountEnabled ne false&$top=999

This still requires you to set the following in the header of the API request:
Verified answer

Expiscornovus 31,671 Most Valuable Professional on 23 Aug 2024 at 09:48:27

Like (2)

Report

Graph API Request to Filter Active Members and Groups

Afaik you can also use an $expand on members. That method does has some limitations but when you use an $expand it should also return details of the groups itself. Might be worth a shot?

Btw, there are also a Transitivemembers method to retrieve users and groups of a group:

https://learn.microsoft.com/en-us/graph/api/group-list-transitivemembers?view=graph-rest-1.0&tabs=http

Community site session details

Graph API Request to Filter Active Members and Groups

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Graph API Request to Filter Active Members and Groups

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates