MS Graph API LastPasswordChangeDateTime not indexed

Thoman, Nick 61 Reputation points
2023-02-13T16:06:41.7766667+00:00

Can LastPasswordChangeDateTime be filtered?

Example:

https://graph.microsoft.com/v1.0/users/?$count=true&$top=999&$orderby=displayName&$filter=(LastPasswordChangeDateTime le 2023-01-09T12:43:39Z)

{
    "error": {
        "code": "Request_UnsupportedQuery",
        "message": "The request uses a filter property that is not indexed",
        "innerError": {
            "date": "2023-02-13T16:05:41",
            "request-id": "3d21e4d4-0e22-4e51-b93d-c2e662bc1aaa",
            "client-request-id": "3d21e4d4-0e22-4e51-b93d-c2e662bc1aaa"
        }
    }
}
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
13,264 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vasil Michev 115.3K Reputation points MVP
    2023-02-13T17:41:56.0266667+00:00

    No, afaik no. Not all properties are supported for server-side filtering. Refer to this article for list of properties supported for $filter: https://learn.microsoft.com/en-us/graph/api/resources/user?view=graph-rest-beta#properties

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.