Thursday, 16 February 2017

Manage the Number of Items should display in SharePoint List or Library

I am going to explain about how to manage the Number of items should display in the SharePoint List and Document Library.
Very important part of using any list or Documents library is to get fast response or can get data soon once requested to get, but it will affect the performance of any List or Library if we have huge data exist on that. Users use to create multiple view for required data and display the same on list may be work till we have less data on the same, in case we have thousands of items in same view will be putting us in difficulties.
So we can limit the amount of items returned can rise performance and constancy, limiting the size means just we will lock the item view display on the screen with specific limitation.
This setting will be application for All List and Library exist beside the SharePoint online or SharePoint 0n-premises.
Below are the steps to configure the same, showing screen shots from document Library:
  • Login to the site and go to site contents page, here open any one of Docs Library.
  • Open Docs file will get open, we can see there will huge data showing or very less data visible on this Library which we can either increase or Limit the Number of items to display. Go to setting page, see below:

  • On the setting page come down to view section and click on any of created view.
  • View page will get open, we need to select item limit option and expand it. See below screen shot for more details:
  • Here we can see Number of Items to display is default set as 30 which we can reduce or increase also. Item Limit: Use an item limit to limit the amount of data that is returned to users of this view. You can either make this an absolute limit, or allow users to view all the items in the list in batches of the specified size
  • We can Limit the total number of items: if we are going to select this option it will show the limited amount of items on the List or library.
  • In case we are going to select extend the items display; maximum we can show 2147483641, see below screen shot for more details.

  • I have selected the 1000 number items to display, it will looks like below screen shot:
  • Same view we will limit the number to display items.
  • See the result;


1 comment:

  1. Thanks a lot for this guide! Though why the result doesn't show on the homepage of the subsite itself?