How can I search for a specific word or phrase in SharePoint List items using filter queries?

88577031 0 Reputation points
2025-02-04T06:57:00.03+00:00

I want to get all SharePoint Online list items which contains a word or a phrase in one of their columns. I tried using contains operator in a filter query parameter, but it did not work. See below screenshot.

Reference: https://learn.microsoft.com/en-us/graph/filter-query-parameter?source=recommendations&tabs=http#operators-and-functions-supported-in-filter-expressions

User's image

I also tried using search query parameter for this, but it did not work as expected. It fetched all of the list items instead. See below screenshot.

Reference: https://learn.microsoft.com/en-us/graph/search-query-parameter?tabs=http

User's image

Please note that I cannot use the Search API for list items, because it does not support site-level search schema. In my case, I have this list already in production, with no site columns, but all list columns. Hence I do not have the default or tenant-level search schema that I can use here.

Please let me know if I am missing anything here. Thanks in advance!

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,948 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.