Hi
I am building up Graph API flow which will be called from PowerApps to get sharepoint list items filtered.
Sharepoint List has more than 30K items.
filtering with operators startswith, eq works fine.
But I would like to use operator in to search within Title column.
link looks like
/sites/{site-id}/lists/{list-id}/items?$expand=fields($Select=Title,ID,Status)&$filter=(fields/Title in 'Approval')&$count=true
I received back
"code": "BadRequest",
"message": "Invalid filter clause: An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartArray' node was expected.",
I tried it also with header ConsistencyLevel: eventual
Any idea please?
