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).

Filter by
Sorted by
Tagged with
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 ...
2
votes
3answers
41 views

List View breaks in Classic with large Document Library

Hello SharePoint Community! So I have a Document Library with more than 5,000 documents in it. That's fine, All the documents have enough meta data that I can create good views to shorten the queried ...
0
votes
2answers
60 views

SharePoint Online list items 5000 +, rest query

I have few lists and libraries which may reach the threshold value of 5000 soon? I have several dashboards which I've used Rest queries to fetch data according to the status of the items. My question ...
0
votes
1answer
43 views

CSOM CAML query with ID row limit 1 returning list threshold error

I'm using the following CAML query in my CSOM code to try to determine the highest list ID in a list. I'm getting the standard list threshold limit error (because the list contains over 23000 items). ...
0
votes
2answers
21 views

How to count items in list view without returning the items?

I get the view limit exception when I make a request to the SharePoint online api that has more than 5K items in the view. I want to be able to count the number of items in the view without returning ...
0
votes
1answer
34 views

List view threshold for administrator not working

My webapplication listview threshold is set to 5000. For administrators it is set to 20000 My list has 6000 items. I have an index on modified date. I create a view sorted on modified. When I open ...
0
votes
1answer
24 views

SharePoint - Change List View Threshold Dynamically CodeBehind

My current SP List View exceeds the threshold limit set in SP Central Admin: Changing the limit from SPCA is not an option for me as it impacts the performance of other sites. Question: How can I ...
0
votes
1answer
42 views

Not understanding why one CAML query is throttled, but not another

I am not understanding why this CAML query from CSOM is getting throttled: <Query> <Where> <And> <Eq> <FieldRef Name="Period" /> <Value ...
1
vote
0answers
39 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 ...
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
1answer
52 views

Microsoft future plans for the “List Threshold” limit, is there a chance to increase the number

One of the main reasons some customers got afraid of using sharepoint online is the list threshold limit of 5,000, which unlike the on-premises can not be expanded. now i know that there are ...
0
votes
0answers
24 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 ...
1
vote
0answers
32 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 ...
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
1answer
39 views

Threshold on SharePoint online list

I have an Infopath form that captures budget lines for different budgets in an SharePoint online list. The list captures the lines for each budget. There can be many budgets and then of course much ...
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 ...
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 ...
1
vote
0answers
187 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
72 views

CAML query returns different data

I created a CAML query that I need to use as a workaround for REST API and the 5k threshold limit: However when I was testing it using the SharePoint CAML Query Helper Online, it returns the correct ...
1
vote
2answers
48 views

How can I locate a missing column in my List Settings?

I have a SharePoint Online list that has recently grown to over 5000 items. Here is what a given entry looks like on the AllItems view, with the column I'm interested in circled in red: When I go to ...
2
votes
0answers
78 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 ...
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 ...
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
107 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 ...
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 ...
1
vote
1answer
43 views

SharePoint Online - view threshold

All my filter columns are indexed, and the result should only return a maximum of 161 items but I'm still getting the view threshold error message -- do I need to index the columns being displayed as ...
0
votes
1answer
31 views

Filter list top 5000

In order to prevent a list view threshold issue I would like to have a list filtered by the last 5000 records. It would be something like Select Top 5000 order by ID Descending. Tried to implement a ...
0
votes
0answers
57 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 ...
2
votes
2answers
137 views

The number of items in this list is approaching the list view threshold, which is 5000 items.

I am working on sharepoint document library inside sharepoint on-premises 2013. the document library contain around 3800 files and folders. so when i went to the library setting, i got this warning ...
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
437 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
396 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?$...
2
votes
0answers
55 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 ...
0
votes
1answer
546 views

Calculated Column Filter fails when list view limit is reached

I have a list with a little over 5000 items in it. I have filtered the data in a Weekly and Monthly view using calculated columns. This works fine until the list hits 5000 items. The filters stop ...
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 ...
2
votes
2answers
445 views

was the sharepoint list threshold increased on SP online?

after doing some testings we found out that our list views surpassing the item limit threshold were still working even when the item limit was greater than 5,000 and it would keep working unless the ...
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 ...
5
votes
2answers
1k views

Threshold is exceeded (>5000 elements) but View still working. Why?

I have a list of the normal Threshold of 5000 elements. This Threshold is exceeded (currently we have round about 5500 elements in this list). However, it is possible to view all elements in the ...
0
votes
2answers
338 views

System.ArgumentException: Column 'ABCIniti' does not exist. It may have been deleted by another user

We are using SP2010 on-premise and InfoPath 2010. Recently we found one of InfoPath library's workflow page got error. After investigate the ULS log, the error is "System.ArgumentException: Column '...
2
votes
3answers
549 views

How to overcome threshold frequency in SharePoint List

We are looking for how to overcome threshold frequency in SharePoint List. Thanks,
1
vote
2answers
4k views

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator while renaming site column

I am getting The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator while renaming site column in SharePoint online using csom. I have ...
0
votes
1answer
98 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
33 views

Item View Limit

I'll do my best to explain this. So I have created a custom list with 5 columns Group (Single line of text) - Not done as choice as using datasheet view to upload these Category (Single line of text)...
0
votes
2answers
254 views

Custom new form not working when list exceeds 5000 items

After 5000 items threshold is exceeded, custom new form stops working even though I did index a couple of columns, and views are working fine, so as default the new form. But when I want to open the ...
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 ...
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. ...
0
votes
3answers
67 views

List View for Most Recent 5000

Is it possible to display the most recent 5,000 items in a list using the ID ? If the answer is yes, then how ? Also, is the ID inherently have an index ? I noticed when I tried to create an Index ...
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 ...
2
votes
3answers
939 views

Calendar View Always shows List threshold exceeded error

I am using Sharepoint 356 (office 365). I recently migrated my site from sharepoint 2007 to 365. I used to have a calendar on my homepage that had 5800 items. Office 365 view limit is 5000. So the ...