Search for items in a list

Question

Hi,
I have a list in format as mentioned below

I would like to search for items only in mentioned list by providing a value.
For instance, if I search for PS, I'm expecting first 2 records to be returned as Team is PS in these 2 records.
Can someone please help with the API specs for this?

Answer 1

Hi @captain_atharv ,

According to my research and testing, please try to use the following Graph API to filter items in a specific list:

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items/?expand=fields&filter=fields/Team eq 'PS'  

Note: You need to set up indexed for "Team" columns .(List Settings ->>Indexed columns)

Hope it can help you. Thanks for your understanding.

-------------------------------------------------------------------
UPDATE-------------------------------------------------------------------

Please try to use the following Graph API to search items in a specific list:

POST https://graph.microsoft.com/v1.0/search/query    

{  
    "requests": [  
        {  
            "entityTypes": [  
                "listItem"  
            ],  
            "query": {  
                "queryString": "PS path:\"https://XXXX.sharepoint.com/sites/zella/Lists/test5\""  
            }  
        }  
    ]  
}  

My test result:

More information for reference: Use the Microsoft Search API to search OneDrive and SharePoint content

---

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.

---