Sharepoint List View Threshold

Question

1. Is it possible to increase list view threshold limitation in sharepoint.
2. We can manage list using creating indexed view but How to manage lookup columns in another list.

Answer 1

Hi @Modus Dev ,

To answer your question:

1)Yes, it is possible to increase list view threshold in SharePoint server as the administrator of Central Administrator, however it is generally not recommended to chang it to avoid performance degradation.

If you still want to do this, please try as follows:

Go to Central Admin>Click Manage Web Applications under Application Management>Select the web application for which you’re adjusting the list view threshold>Select General Settings then Resource Throttling:

2)Although we can index a lookup column to improve performance, using an indexed lookup column to prevent exceeding the List View Threshold doesn't work.

So we suggest you use another type of column as the primary or secondary index.

In addition, please note that there are no more than 12 lookup columns displayed in the list view, which will cause the same threshold issue.

More information for your reference:

https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59#ID0EABAAA=Server

https://support.microsoft.com/en-us/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0

https://natechamberlain.com/2018/05/21/how-to-resolve-sharepoint-list-view-threshold-error-the-view-cannot-be-displayed-because-it-exceeds-the-list-view-threshold/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.