Filtering and Expanding Users

Question

Hello,

Has anyone used $filter and $expand at the same time?

I’ve tried with top + select + filter + count and this works

 https://graph.microsoft.com/v1.0/users?$top=13&$select=id,givenName&$filter=endsWith(mail,'@hello.com')&$count=true  

Tried top + select + expand + count and this works as well

https://graph.microsoft.com/v1.0/users?$top=13&$select=id,givenName&$expand=manager($select=id,givenName)&$count=true  

But once I try both filter and expand it doesn’t work:

https://graph.microsoft.com/v1.0/users?$top=13&$select=id,givenName&$filter=endsWith(mail,'@hello.com')&$expand=manager($select=id,givenName)&$count=true  

Answer 1

Hi @Vivian Escalante

I am able to replicate same scenario. As per this Query Parameters documentation "$expand is not currently supported with advanced queries."
(endsWith) operators on the $filter is considered as Advanced query that is why expand is not working in the above Graph API.

As a workaround you can use
https://graph.microsoft.com/v1.0/users?$count=true&$top=13&$select=id,givenName&$filter=startsWith(mail,'Alex')&$expand=manager($select=id,givenName) this Graph API endpoint. Please refer to the below sample screenshot.

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.

Answer 2

@ShivamDhiman-1582 Hello, thank you for the response. Unfortunately this isn't really a workaround for what we want to achieve. We want to only return those with emails ending with a specific domain.

Answer 3

Hi @Vivian Escalante , since this feature is presently not available, you can submit a feature request idea using this support link, which will be monitored by Microsoft team and make the enhancements to Microsoft Graph APIs. I will also upvote for you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Hi @Shivam Dhiman , in my case I have to filter on an extended attribute, starts with filter could be fine but it does not work

https://graph.microsoft.com/v1.0/users?$count=true&$select=id,givenName&$filter=startsWith(onPremisesExtensionAttributes/extensionAttribute10,'A')&$expand=manager($select=id,givenName)

Answer 5

Hi @Shivam Dhiman , could you please see my previous answer? I forgot to tag you