"Sorting not supported for current query." error when sorting List members API

Question

I keep getting the above error when try to sort the list on displayName, however sorting is clearly supported according the example below: https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=csharp#request-3

I tried adding ConsistencyLevel headers and count query param with no luck.

var users = await GraphHelper.client.Users
    .Request() //new List<QueryOption>() { new QueryOption("$count","true") }
    .Header("ConsistencyLevel", "eventual")
    .Filter($"accountEnabled eq true and extension_{AppConfig.variable["B2C:ExtensionId"]}_BankId eq '{bankId}'")
    .OrderBy("displayName")
    .Select($"id,displayName,identities,extension_{AppConfig.variable["B2C:ExtensionId"]}_BankId").GetAsync();

Same query works in graph explorer but not in the REST API.

Answer 1

I suspect that you are seeing this discrepancy because of incorrect setup in POSTMAN and code.

You can setup POSTMAN by following this step-by-step guide. A quick glance of steps is below:

• Registering the Azure AD App
• Get admin consent for the app
• Get access token using the app
• Make Microsoft Graph API call using the access token as bearer token

Similarly, please check similar setup of C# code as well.

---

Edit:

It seems there are some rules that we need to follow while using filter and orderby:

Hence, when I followed the rules and ran https://graph.microsoft.com/beta/users?$count=true&$filter=startsWith(displayName,'B')&$orderby=displayName desc query, it works: