How to update item limit in every list/library view in the farm

Glenn Skinner 1 Reputation point
2022-12-20T16:39:16.703+00:00

We have a customer who has a number of sites all with lists/libraries and different list views all with the default item limit. We need to iterate through every list view and change the item limit. We dont nned to change the default 5000 threshold limit but they do want the item limit in the view changed from 30 to 3000 for example

Microsoft 365 and Office SharePoint Development
Microsoft 365 and Office SharePoint For business Windows
Windows for business Windows Server User experience PowerShell
{count} votes

2 answers

Sort by: Most helpful
  1. Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee
    2022-12-21T07:05:00.433+00:00

    Hi @Glenn Skinner ,

    Thanks for the post.

    According to the research, you could globally change the default view's item limit by using PowerShell.
    And you may refer to this answer: Globally change the default view's Item Limit from 30 to 300?


    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.


  2. Limitless Technology 44,746 Reputation points
    2022-12-21T08:50:24.073+00:00

    Hi,

    Thank you for posting your query.

    Kindly follow the steps provided below to resolve your issue.

    To work around this issue, review the recommendations, techniques, and tips outlined in Manage large lists and libraries in SharePoint.

    You can store up to 30 million items or files in a list or library. Filtered views of large lists have a similar experience to other lists. However, when a list view shows more than 5000 items, you may run into a list view threshold error.

    Go to this link for your reference and other troubleshooting procedures https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59

    https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/items-exceeds-list-view-threshold

    Do not hesitate to message us if you need further assistance.

    If the answer is helpful kindly click "Accept as Answer" and up vote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.