How to use multiple people picker fields or other fields filter in threshold larger list in rest api query?

Question

We have SharePoint online list which exceeds 5000 items threshold limit.

I need to filter above list data into using multiple people or group fields or other multiples fields like..

(TestEmail1/Email eq 'abc@xyz .com') or (TestEmail2/Email eq 'abc@xyz .com') or (TestEmail3/Email eq 'abc@xyz .com') in rest API query.

below is rest api query.

/_api/web/lists/getbytitle('abc')/items?$select=Id&$filter=(TestEmail1/Email eq 'abc@xyz.com') or (TestEmail2/Email eq 'abc@xyz.com') or (TestEmail3/Email eq 'abc@xyz.com') or (TestEmail4/Email eq 'abc@xyz.com')  

Please suggest me any solution for this issue in JavaScript.

@Baker Kong-MSFT

Answer 1

Hi @Pramod Butte ,

Per the test, SharePoint Online large list didn't support to filter multiple person fields even add the columns as indexed column.

Otherwise it will throw the error "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."

For single person field, the workaround is to add it as indexed column and filter it with user id instead of EMail like the code snippet in attachment, you can get the user id using this endpint /_api/web/siteusers :

51132-code.txt

It will have a next property for items to paging:

Thanks
Best Regards

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.