PowerShell The attempted operation is prohibited because it exceeds the list view threshold
Note: Video showing resolution in SharePoint Online at bottom of post. Show SharePoint lists have a default limit of 5,000 items per view. But lists can contain 30 million items (just not all available in one view). Since youre reading this, perhaps youve already learned this from an error message such as:
Or this one when attempting to filter by column headers:
First of all, when in doubt, refer to the documentation provided by Microsoft. Read it carefully to understand limitations in your specific environment, explanations of various actions and rules and the permissions required to correct the issue. Heres my summarized version: Solution #1: Index Columns Used as View Filters(works for both On-Prem/SharePoint Server AND O365/SharePoint Online)
Solution #2: Increase the Threshold(On-Prem/SharePoint Server Only)Ask an administrator to raise the threshold or do it yourself. Please know that thresholds exist for a reason, however, and from a scalability viewpoint this may not be the best action to take as it can affect performance. Learn more on scalability and capacity planning concernshere.
O365/SharePoint Online Limitations
See more ideas and explanations in Microsofts support article. Spread the word:
Like this:Like Loading... Related |