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

Notifications

Announcements

Community site session details

Community site session details

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

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

(0) ShareShare
ReportReport
Posted on by

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,474 Super User 2025 Season 2 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,073 on at

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

  • Community Power Platform Member Profile Picture
    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,073 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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard