Graph API SharePoint List Search (Contains & StartsWith) Not Working

Question

Hi,

I am trying to search the SharePoint List items through Graph API using the keyword filter=contains({fieldname}, '{fieldvalue}') also tried with filter=startswith({fieldname}, '{fieldvalue}'). In the fieldvalue I have given some string values, but it seems both the conditions is not working.

Just want to confirm if Graph API supports contains & startswith keywords?

Thanks in Advance.

Answer 1

Hi @L.K.Prabu ,

Microsoft Graph for listitem-list, $filter supports startsWith on text fields only, currently there is no support for contains function.

GET /sites/{siteId}/lists/{listId or Title}/items?$expand=fields&$filter=startsWith(fields/{fieldName},'{stringValue}')  
Prefer: HonorNonIndexedQueriesWarningMayFailRandomly  

My test result with startsWith

From your test try changing ?expand=fields&filter=contains(fields/AccountNumber, '1102') to ?$expand=fields&$filter=startsWith(fields/AccountNumber, '1102'), and it would work only if AccountNumber is a text filed type.

Hope this helps.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".