Questions tagged [list-view-threshold]

The list view threshold is a value defined in Central Administration that limits the number of items that may be viewed or acted upon at a time, and is intended to prevent a performance impact that may be incurred if such an action is taken. This may be bypassed at the administrator's discretion by using object model code, or during specific hours of the day (usually overnight).

59 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
799 views

SharePoint Online list view threshold error in a lookup column

I am facing an issue with lookup column in the list forms due to list view threshold limit (5000 items). The parent list is having more than 5000 items. Hence the lookup field is not getting ...
6
votes
2answers
717 views

How to fix 5000 Limit for Views but without breaking Alerts

So recently I saw the infamous message about getting close to the 5,000 item limit. After spending a couple of days doing some testing, it seemed like the best option would be to simply Index the ...
3
votes
1answer
164 views

Threshold error when viewing recurring events from calendar view

We have a SharePoint online calendar list with more than 5000 items. We have created a calendar view to show just one recurring event. But when we open the event to view the details it is showing ...
3
votes
1answer
106 views

GetListItems returns only open items

I'm using SharePoint 2010 SOAP interface with Perl. Sometimes it is necessary to crawl through closed items and remove attachments, but GetListItems returns only active items. How to I get all items ...
2
votes
0answers
134 views

Large Dropdown Lookup with Autocomplete

Wondering if anyone can point me in the right direction. Requirement is a drop-down field in a SharePoint Online list that references a customer table in SharePoint Online. Of course, the customer ...
2
votes
0answers
74 views

How to populate a SharePoint person/group column with a SharePoint group using Microsoft flow

I have a SharePoint task list that has exceeded 5000 items. I have a created a custom list that has just about all the columns of the task list. My intention is to copy a large backlog of the items in ...
2
votes
0answers
75 views

Recurring Event DispForm - Exceeds ListView Threshold

When I open recurring events (DispForm.aspx) I'm getting the pesky "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator". Calendar views with ...
2
votes
0answers
106 views

Filtering a Grouped By view by current year in SharePoint Online

I am aware of this and have done this multiple times before and it used to work fine. However, currently I am facing unexpected behavior and it's different in Modern and Classic views. I have a list ...
2
votes
0answers
54 views

SharePoint 2013 List View Threshold with Query String Filter

I have done some research and I think I am ok, however I cannot take the risk of not knowing for sure. I have just developed a site that will host 8000 events per year (8000 List items) and there ...
2
votes
1answer
971 views

Threshold error when trying to change URL of the Site

I have a weird problem. This happens on a sub site in a site collection and both sub site and site collection does not have any big lists that exceed the threshold. However when site collection ...
2
votes
1answer
200 views

Listview threshold in sharepoint 2013 via console application

I found so many questions about list view threshold in SharePoint. As Microsoft recommend items should not exceed 5000 (configurable in central admin). So i tried a sample piece of code to check where ...
2
votes
1answer
62 views

threshold plan ahead approaches

I would like to ask which are the approaches being used to plan list implementation taking scalability into account. I know that we can create indexes, subfolders, multiple views and so on, but that ...
2
votes
0answers
183 views

Understanding list view threshold (I expected an exception)

I created a list with numerous lookup columns (more than 12) and many many list items (more than 30.000). The "All List Items" view works perfectly. This is expected However I expected a sorting on a ...
1
vote
1answer
18 views

SharePoint Online Search Result not returning DisplayForm from Huge Library

I am trying to configure the search result in SharePoint Online. We have a huge document library, with custom columns to modify the properties on a daily basis. The search is returning only the ...
1
vote
0answers
38 views

Large list backup in sharepoint online - suggested way

we need to backup a large list in our sharepoint online environment, the following things needs to be considered The List has more than 10000 items The List has a lookup column Our environment does ...
1
vote
0answers
31 views

SharePoint Online - Get items from folder threshold issue

I have a SP List with multiple sub-folders. Each item in sub-folder has status column as Not Started/Ready Total Items in list with Status Not Started -20 Total items in list with Status Ready -7000 ...
1
vote
0answers
184 views

JSOM: CAML Query List view threshold error for large lists

This is a topic discussed many times before but I have a peculiar case now and need some expert opinion on this.Below is a sample scenario I am trying to test: My List Set up: List has 10k items. ...
1
vote
1answer
77 views

Query large list with indexed column doesnt work

I am querying a large list and it works well if I don't put any condition in where clause. I am trying to get items greater than some ID(actual requirement is to get items Created > Today()), as ...
1
vote
1answer
77 views

How do i dynamically load a large list based on a filter?

I have written some javascript that generates a link with filters for a list of items. It has a couple of drop downs to choose certain filter values. This is all good until the list reaches 5k items. ...
1
vote
0answers
83 views

sharepoint limit

I have a templates library in SharePoint with around 80K items (while I know the threshold limit is 5K) - this library uses no folders, but just enterprise keywords and metadata - can anyone suggest ...
1
vote
0answers
239 views

Avoid threshold limit with view using “Or condition” on person columns

Here is my issue: I have a sharepoint 2013 list with more than 5 000 items inside. In order to avoid threshold limit I indexed several columns and created views using these columns. Most of the views ...
1
vote
0answers
78 views

List View Threshold - Future Planning

Regarding List View Threshold limits (LVT), I have done a lot reading and I am starting to wonder even with indexed columns will our current system scale? What happens if we have a list called ...
1
vote
0answers
127 views

CrossListQueryCache - get 10 items on indexed column

I have a question, basically I build a query and use the CrossListQueryCache to retrieve all the required items. Now all was good and well but there is a problem: lists are big some of them more than ...
1
vote
0answers
23 views

Define Filter web part query order for List view

I have added one list view on SharePoint page. It has several filter web parts added to it. This list has huge data. So I need to define the order for the filter web part so that Indexed column filter(...
1
vote
0answers
332 views

List View Threshold - Date Filter

We have a list with ~6000 items and an indexed column Date Created. There are two filtered views: Items Younger Than 30 Days Filter: Greater Than [Today] - 30 This view works correctly. Items ...
1
vote
0answers
73 views

ListViewThreshold - Filtering a view

I have a SharePoint List that is over the 5000 List View Threshhold. I have a filtered View of this list that has only 150 items. I have used Indexed Columns and ensured the first filter in my view ...
1
vote
2answers
163 views

How to handle list threshold 5000 for filtered items

Its SharePoint online. We have indexed all the column which are being used to filter/query. A total number of items in the list are around 100 thousand. Filter works perfectly fine. e.g. if we ...
1
vote
2answers
734 views

Using Export to excel in list which has exceeded threshold limit

I have a requirement to export all items to excel in a list which has exceeded the threshold limit. I've already tried using power query but since I have some null values in people picker fields in my ...
1
vote
2answers
2k views

Create SharePoint List View to show last N items

I have one list i.e-Tickets which is having more then 300K records. There are more than 10 views, now no one view showing items but it is giving threshold limit warning. Threshold limit we set as 80K. ...
1
vote
0answers
47 views

Sum not adding up on list that exceeds threshold

I have a list that has about 10,000 items. There are 5 locations each with 2000 items. Each item has a qty of 1 so the Sum of the location should be 2000. When I look at the Sum however it shows ...
1
vote
0answers
181 views

SP2013 Changing URL of web results in List View Threshold error

Similar to this question, however the answer seems to have not paid attention to the actual problem- TechNet Forum I am attempting to change the URL of one of my site's child webs through "Site ...
1
vote
2answers
1k views

5000 item limit prevents opening item even if view works fine

I have a Sharepoint 2013 task list with 5001 items in it. I have talked with the department that uses it about limiting the size by clearing out old items, but that is probably a little ways off. ...
1
vote
2answers
2k views

List View Threshold incorrectly throttling datasheet view

We have a large SharePoint 2010 installation. On many sites, I use Export to Excel or a datasheet view to view lists larger than 5,000 items with no issue. If the list has more than 50,100 items, we ...
1
vote
2answers
292 views

GetItems with CAML against lookup on online throws “list view threshold”-error

I want to query for items where a lookup has a title which contains some text. The list has over 5000 items, but the query result will return fewer, so it should work. This query works, querying for ...
0
votes
0answers
17 views

SharePoint online and SharePoint 2013, is there any problem if i add indexes to our lists/libraries which already contain data

I read a lot of articles about list threshold and indexes. for example some of the weird things i read, is that if we have a list/library which already exceed the threshold (5,000), and we tried to ...
0
votes
0answers
23 views

Dealing with List View Threshold

I have a list that has 5586 items so it has gone over the List View Threshold. I'm a site collection admin, but don't have access to central admin. So we can't change the limit. I've been trying to ...
0
votes
0answers
21 views

Why my list view which is filtering items based on an Indexed column, and which will return 2950 items, will show threshold error for end users

I am facing this strange and UN-logical behavior inside our custom list view. now we have a sharepoint enterprise farm 2013. and the list threshold for the web application is set to the defualt which ...
0
votes
1answer
42 views

Is using metadata navigation and filtering a way to bypass the list/library threshold

I have a document library inside our sharepoint on-premises 2013 enterprise server. and the document library contain a cusotm column of type drop-down named "ch". currently the document library ...
0
votes
0answers
37 views

Folder did not break the 5k List View Threshold

I have a document library with ~20k Folders. SharePoint Online is telling me, that the list threshold is reached even if I navigate into a folder which only 4 documents in it. But Manage large lists ...
0
votes
0answers
56 views

Adding an Index column on my list for the “Modified” column, did not allow me to show more than 5,000 items on the list view

I am working on a SharePoint 2013 on-premises farm, and i have a document library which have 5651 documents, and i got this message that the library exceeds the threshold:- and when non-admin users ...
0
votes
2answers
36 views

List View Threshold limit with “Read items that were created by the user”

With the option "Read items that were created by the user" on a SharePoint list I was not expecting users to hit the 5,000 item List View Threshold limit. In this scenario are the list items filtered ...
0
votes
2answers
432 views

Multiple filters on a large list using REST

I am running into an issue when using the listdata.svc REST API on large lists. I have a query that looks like: .../_vti_bin/listdata.svc/MyList?$filter=(substringof('<query>',LastName))or(...
0
votes
1answer
393 views

REST API - List view threshold

We have a list that is now over 5000 and the following stopped working. All the fields used in filters are indexed var requestPendUri = webAbsUrl + "/_api/web/Lists/getByTitle('LeaveRequest')/Items?$...
0
votes
0answers
67 views

Listview threshold limit reached despite returning less than 5000

I have a sharepoint list with 20k+ records. I'm using the ID filter to get the records where ID is less than 1,500. I know ID field is automatically indexed so I should have only 1,500 records ...
0
votes
1answer
51 views

unable to do any operations of splist as List view threshold crossed 5000 Items in SPO

Using the manual approach, I have copied some 5100 list items from my SP 2010 site's splist into O 365 - SPO list. But the issue is that,i am unable to do any kind of operations because i am ...
0
votes
1answer
97 views

options for enhanced lookup column in “new experience” SharePoint Online

I have a site in SharePoint online which is using a lookup column to a large list (like 25k) of items. I'm getting the list view threshold error when trying to add metadata with that lookup column. ...
0
votes
1answer
40 views

List View Threshold Issue for List

I am getting the Error when clicking on "Add new item" for a list.(list has crossed 5000). So i increased the LVT, indexed the columns and filtered the list using the index column to bring the list ...
0
votes
0answers
479 views

Optimal way to query over 5000 items in a SharePoint Document library - C# CSOM

I am currently using the below code to query over 5000 items in a SharePoint Online Library. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<View Scope='RecursiveAll'&...
0
votes
1answer
158 views

List View Threshold and Managed Metadata fields with multiple values

We have a large document library with more than 25.000 files in it. All files have set managed metadata properties (multiple values allowed!) and some other fields for filtering this list and to get ...
0
votes
1answer
658 views

Infopath Form - Edit Mode - Error related to list view threshold in SharePoint Online

I have an Infopath 2007 Form. When I open the edit form(already saved form) , I am getting the below error: The query cannot be run for the following DataObject: MyFormGetInfo InfoPath cannot run ...