Graph API Sharepoint list, filter by createdDateTime

Question

This graph query

    https://graph.microsoft.com/v1.0/sites/<Site ID>/lists/<list ID>/items?$filter=fields/Created+ge+'2021-08-01T08:00'  

for the custom column Created gives results, but the filter produces inaccurate results.

        {  
            "columnGroup": "Custom Columns",  
            "description": "",  
            "displayName": "Created",  
            "enforceUniqueValues": false,  
            "hidden": false,  
            "id": "12345",  
            "indexed": true,  
            "name": "Created",  
            "readOnly": true,  
            "required": false,  
            "dateTime": {  
                "displayAs": "default",  
                "format": "dateTime"  
            }  
        },  

When I try

https://graph.microsoft.com/v1.0/sites/<Site ID>/lists/<list ID>/items?$filter=createdDateTime+ge+'2022-01-01T00:00:00Z'  

I get

{  
    "error": {  
        "code": "BadRequest",  
        "message": "Invalid filter clause",  
        "innerError": {  
            "date": "2022-08-24T13:13:55",  
            "request-id": "12345",  
            "client-request-id": "678910"  
        }  
    }  
}  
  

Does the list item query not support "createdDateTime"? Can I eventually query the Created column differently, since it is a dateTime column?

Answer 1

Yes , This is a known issue, the /sites/{site id}/lists , currently filter is not supported for list fields such as "Name", "lastModifiedDateTime', "createdDateTime',webUrl...etc.

If you want this feature to be added, then you can submit User Voice to add support for the filter.

----------

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 2

@Dev 9 hi friend, could you try to add new column for saving DateTime as string ?

Then, the request should update this column in every add item/ edit item.