SharePoint Online list view threshold limits for indexed columns and pagination
28K reputation · 18 Oct 2020, 20:31 UTC
Goal: Determine the maximum number of items that can be queried reliably in a SharePoint Online list when the item count exceeds the 5,000‑item view threshold in a production environment.
Constraints: The threshold applies to CAML, REST, and PowerShell read operations that do not filter on an indexed column; adding an index to a filtered column can raise the effective limit to 20,000 items, but each list allows only 20 indexed columns; pagination alone does not bypass the threshold unless the initial query returns fewer than 5,000 items.
Uncertainty: Teams must decide whether to invest in column indexing, adopt strict pagination patterns, or use the Content Search API, and how the 20‑index limit influences long‑term scaling as lists grow beyond 20,000 items.
What is the practical query limit when a filtered column is indexed?
How does the 20‑index per‑list limit affect scaling strategies for lists that may exceed 20,000 items?
When should pagination be preferred over indexing, or vice versa, to stay within the threshold?
microsoft-365