0

I'm trying to use SharePoint rest API to get items from a SPO list. It has around 15K items. But I'm using filters and expecting less than 30 items in the result. It works fine when normal columns are used for filtering. But when I use people picker column, it throws the below error:

    <m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<m:code>-2147024860, Microsoft.SharePoint.SPQueryThrottledException</m:code>
<m:message xml:lang="en-US">The attempted operation is prohibited because it exceeds the list view threshold.</m:message>
</m:error>

Below is the query I used:

https://test.sharepoint.com/sites/SiteName/_api/web/lists/getbytitle('ListName')/items?$select=ID,Employee/EMail,Employee/Title,Employee/JobTitle,Employee/Department&$expand=Employee/Id&$filter=(Employee/email address removed for privacy reasons%27)

Could anyone help me fix this issue?

Improve this question

1 Answer 1

Reset to default
0

Indexing the affected column may help you, for more information check out Microsoft's support article on managing large lists:

Manage large lists and libraries

Improve this answer
11
  • The column is already indexed.
    – Robin Roy
    Jul 22, 2022 at 15:43
  • Is the person column single value or multi value?
    – Callum Crowley
    Jul 22, 2022 at 15:45
  • It's a single value column.
    – Robin Roy
    Jul 22, 2022 at 15:51
  • Strange, documentation suggests that it's a supported column type for indexing. Have you tried only returning/selecting that people column in your query?
    – Callum Crowley
    Jul 22, 2022 at 15:54
  • _api/web/lists/getbytitle('listname')/items?$select=Employee/EMail&$expand=Employee&$filter=(Employee/EMail eq 'user@domain.com') - tried this and it did not work.
    – Robin Roy
    Jul 22, 2022 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.