Filter SharePoint List Items by lastModifiedDateTime using Graph API

Question

I am trying to filter a SharePoint List of Items to only get those that were modified within the past day. According to the following Graph API documents, I should be able to use the

$filter=lastModifiedDateTime ge {24 hours ago}

query parameter

https://learn.microsoft.com/en-us/graph/api/listitem-list?view=graph-rest-1.0

https://learn.microsoft.com/en-us/graph/api/resources/listitem?view=graph-rest-1.0

A sample URL I am using is:

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items?$filter=lastModifiedDateTime ge 2025-04-28T00:00:00Z

I am getting back an "Invalid request" from Microsoft without any real reason why.

If I dont add a filter, I am able to return all the items without issue.

Use this https://graph.microsoft.com/v1.0/sites/SiteID/lists/ListIF/items?expand=fields&$filter=fields/Modified gt '2025-02-27' — Rukmini
– Rukmini, Commented Apr 30 at 4:19

Rukmini · Accepted Answer · 2025-04-30 07:27:19Z

0

Note that: In your scenario, filtering based on certain properties returned by the Microsoft Graph API—such as lastModifiedDateTime or createdDateTime—is not supported.

For example, using a query like /items?$filter=lastModifiedDateTime ge '2025-02-27' will result in an "Invalid request" error.

To resolve the issue, you need to make use of the auto generated SharePoint list item fields Created or Modified:

Hence to filter SharePoint List Items use the below query:

https://graph.microsoft.com/v1.0/sites/SiteID/lists/ListID/items?expand=fields&$filter=fields/Modified gt '2025-02-27'

enter image description here

answered Apr 30 at 7:27

Rukmini

17.7k2 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Daryl Clark Apr 30 at 12:54

Thanks, this is exactly what I was looking for and works as expected. Can I ask where you found this? i don't see it documented anywhere.

Rukmini Apr 30 at 13:11

Referred from here stackoverflow.com/questions/50930871/…

martinm · Accepted Answer · 2025-04-30 07:02:48Z

0

The endpoint sites/{site-id}/lists/{list-id}/items doesn't support filtering by the lastModifiedDateTime property, but you can filter items by the Modified field.

Values in lastModifiedDateTime and Modified are identical for each item.

/sites/{site-id}/lists/{list-id}/items?$filter=fields/Modified ge '2025-04-29T00:00:00Z'

For some reason the field name Modified is case sensitive

answered Apr 30 at 7:02

martinm

22.1k4 gold badges45 silver badges72 bronze badges

Collectives™ on Stack Overflow

Filter SharePoint List Items by lastModifiedDateTime using Graph API

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related