web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / $filter is not working...
Power Automate
Answered

$filter is not working in REST API call to get required items

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Team,

 

we have a connector to pull the groups where the user is a member of

https://graph.microsoft.com/v1.0/users/userEmailId/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled

muralikrishna12_0-1670498263230.png

it returns only the first 100 items only 

here is the output

{
 "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups(id,displayName,securityEnabled)",
 "@odata.nextLink": "https://graph.microsoft.com/v1.0/users/a1140e29-d7b1-4e29-8e92-f47544b14046/MemberOf/microsoft.graph.group?$select=id%2cdisplayName%2csecurityEnabled&$skiptoken=RFAAAAFAAAAP_P1E7jbylBi5A25lAAAAAAAAAAAAAXMS4yLjg0MC4xMAABSoKoWXoRDAAAA",
 "value": [
 {
 "id": "a759-4dc9-8204-9eecd821b89e",
 "displayName": "G ESI USLegal",
 "securityEnabled": true
 }]
}

here is the filter query where we are trying

https://graph.microsoft.com/v1.0/users/useremail/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled&$filter=startswith(displayName,'D')

 

here is the Graph Explorer output 

muralikrishna12_1-1670498605029.png

any help here on how to filter using startwith 

or how to loop next items using OdataNext 

 

Your reply is really appreciated.

 

Categories:
I have the same question (0)
  • Verified answer
    lbendlin Profile Picture
    8,726 Super User 2026 Season 1 on at

    Case sensitive maybe?  startsWith  ?

     

    Use the $filter query parameter to filter a collection of objects - Microsoft Graph | Microsoft Learn

  • VictorIvanidze Profile Picture
    13,081 on at

    The error message is quite informative - not supported.  Don't use startsWith. Try to use eq.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @VictorIvanidze @lbendlin 
    it was a mistake from my end, because I missed the letter "s"

    it should be "startswith" but tried it like "startwith" and hence I get the error.

    I updated the query when I posted the post here, working fine.  

  • VictorIvanidze Profile Picture
    13,081 on at

    Hi @Anonymous,

     

     please do me a favor an confirm the following request is working for you:

    https://graph.microsoft.com/v1.0/me/MemberOf/microsoft.graph.group?$select=id,displayName,securityEnabled&$filter=startsWith(displayName,'D')
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @VictorIvanidze 
    Yes, it's working what's wrong ..? maybe you might have missed the Request Header

    Make sure you have to add a request header. please check the below screenshot. Just now executed and shared the screenshot.

    muralikrishna12_1-1671457255818.png

     

    Let me know if you need any help

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 223

#2
David_MA Profile Picture

David_MA 195 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 167

Last 30 days Overall leaderboard