Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Graph API Request to F...
Power Automate - Building Flows
Answered

Graph API Request to Filter Active Members and Groups

(2) ShareShare
ReportReport
Posted on by David_MA 7,541
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
  • Suggested answer
    David_MA Profile Picture
    David_MA 7,541 on at
    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 Profile Picture
    Expiscornovus 30,664 on at
    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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans