sharepoint graph api filtering based on a list column value

Question

my query https://graph.microsoft.com/beta/sites/mytenant.sharepoint.com:/sites/mysite:/lists/OEC_Docs?select=id,name,lastModifiedDateTime&expand=items(expand=fields(select=Title,Attachments,OptyNumber))&filter=items/OptyNumber eq '123'

fails with

{
  "error": {
    "code": "BadRequest",
    "message": "Invalid filter clause",
    "innerError": {
      "request-id": "f6426b70-ebe0-44ca-9439-34e1c94f19b0",
      "date": "2018-11-14T00:23:30"
    }
  }
}

where as without filter clause it works fine. based on docs it should work fine. please advise

Answer 1

You can try filtering list items by using similar query as given below:

For List on root site:

https://graph.microsoft.com/beta/sites/mytenant.sharepoint.com/lists/MyListName/items?expand=fields(select=ID,OptyNumber)&filter=fields/OptyNumber eq '123'

For List on subsite:

https://graph.microsoft.com/beta/sites/mytenant.sharepoint.com:/mysite:/lists/MyListName/items?expand=fields(select=ID,OptyNumber)&filter=fields/OptyNumber eq '123'

Note : In case it gives an error to index the field on which you are filtering the list items, try adding an index to that field.

Source: Add an index to a SharePoint column.