Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
2answers
34 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
44 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
27 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
130 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
31 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 ...
1
vote
2answers
139 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
40 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 ...
4
votes
2answers
237 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
113 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
267 views

How to overcome threshold frequency in SharePoint List

We are looking for how to overcome threshold frequency in SharePoint List. Thanks,
0
votes
2answers
538 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
0answers
30 views

How do Documents Center and Records Center alleviate list view theshold

It is found that Documents Center/Records Center templates being listed as one of several methods to circumvent the list view threshold restriction in SharePoint(SQL truly). I also understand now ...
0
votes
1answer
58 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
32 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
155 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
35 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
51 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
55 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 ...
0
votes
0answers
14 views

filter lists that have a lot of items

I have 2 lists on my sites home page. They both have 5000 items. I cannot figure out how to apply a filter so that i can see the content instead of just this error message. Here is what i have tried. ...
1
vote
0answers
51 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
507 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 ...
4
votes
1answer
249 views

Fetching and displaying more than 5000 list items

I am aware of the list items threshold of 5000 items. But I need to display more than 5000 items on a SharePoint Hosted Addin and on a .net website. How can I overcome this constraint? Also, I do ...
0
votes
1answer
33 views

Receiving List View Threshold error with no lists containing over 5000 items?

1) No list in my entire site collection is over 2000 items. 2) Throttling for lists is set to 5000 items. Why, when I export my site collection and import into my development farm, do I receive a ...
0
votes
1answer
359 views

Error while Refreshing Excel data using connection with SharePoint Online List

We have created a SharePoint list with 50000+ items in it which has different views. We exported the same SharePoint list using Export to Excel functionality. After that we created a dashboard on ...
0
votes
0answers
329 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
0answers
53 views

List Thresholds Filter

I noticed something odd when changing the filters on a list view for a list of over 5,000 items (threshold). I have a filter on an indexed date column. If I expand the date range to include over 5,...
0
votes
1answer
53 views

Advice on SP2013 Contact list with over 5000 items to work as Lookup for document information panel

Disclaimer: I am completely new to Sharepoint and web design. Sharepoint 2013, on-premises. The company needs to have multiple document libraries and it is necessary to be able to tag documents with ...
1
vote
4answers
307 views

How to Decrease the Threshold limit to 1000 in SharePoint List?

Yes, you have read it correctly. How to decrease the threshold limit to 1000. I need to fix an issue "Time Out Error" which occurs after deleting 3000+ items. I need to resolve this issue when it ...
1
vote
1answer
110 views

List threshold - When will the CAML query fail? [closed]

From the blog it seems that If my CAML - internally fired by Nintex's query list action - has a filter on a list which has more than threshold items it's prone to failure. Question: Will it fail if ...
1
vote
0answers
134 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
1answer
20 views

Having multiple indices may freeze entire DB?

Here is the post for reference on recommendation to create indices in list. It makes sense to create minimum indices. I've a case so I needed SharePoint community's help in understanding if in worst ...
1
vote
0answers
62 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
1answer
238 views

Delete Items After List View Threshold Breached

So I was doing a migration the other day, and due to poor planning on my part a situation has now arisen where certain subfolders (each subfolder relates to a single property) now contain over 5000 ...
0
votes
1answer
104 views

Indexing “Task Outcome” Column - possible?

We've just had a Workflow History list hit 5000 items - yay people are using sharepoint! A naive "Open Items" view filters on "Task Status" <> "Completed" and can be made to work with an index, ...
0
votes
1answer
57 views

List Threshold persists even after filtering

I have a List which had columns indexed. The list exceeded 5000 items. Now it is not allowing to add new item displaying error: This view cannot be displayed because it exceeds the list view ...
5
votes
0answers
512 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 ...
13
votes
3answers
2k views

When SharePoint list with 5000+ items queried with ID returns expected result but with any other column gives threshold error

I am trying to query a SharePoint list which has more than 5000 items. When I run filter query with ID, it returns the expected results. But when I run the same query with any other column it throws ...
1
vote
0answers
87 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
2answers
3k views

SharePoint CAML query to retrieve the item more than threshold limit

I facing a problem while retrieving the list data from SharePoint online. I have list items around 20,000. I am using a caml query to retrieve the data based on conditions in dotnet csom. it has 5300 ...
0
votes
0answers
49 views

Need To Display Latest Documents on Top of Library which has crossed Threshold of 5000 Items

I am aware of the 5000 document limit in SharePoint 2010 with regards to list views, however I was under the impression that it would automatically default to showing only the 'newest results' in each ...
6
votes
3answers
601 views

SharePoint list 5000 item threshold with indexed column confusion

Today I have encountered the 5000 limit error even though my view is filtered on an indexed column. I believed that because the filtered view was on an indexed column then the result could return more ...
2
votes
3answers
2k views

How to create an index on a large list in SharePoint Online

I am using SharePoint Online and have a large list exceeding 50K items. When attempting to create an index I receive the error that the list exceeds the list view threshold. The solution to this ...
4
votes
2answers
527 views

Archiving strategy for list with over 5000 items

On SharePoint Online, I've got this list which just recently went over 5000 items. We have indexed columns and filtered list views in place in preparation for this, but it's still not enough and is ...
0
votes
1answer
136 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 ...
1
vote
1answer
153 views

Do Document Sets work like Folders as far as the List View Threshold is concerned?

We have a small SharePoint deployment with a handful of team sites deployed. One of these sites had a document library that recently hit the list view threshold (currently set to the default of 5000)....
1
vote
1answer
34 views

List still nearing view threshold despite filter

We added a filter to our list to avoid reaching the view threshold (original question was here: SharePoint List View Filter display 1 week) but despite the filter being active (currently the view is ...
0
votes
1answer
414 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 ...
0
votes
1answer
153 views

Create a new Edit Form on List with over 5000 items in SharePoint Designer

Note: My SharePoint tenant is locked down and we don't have access to deploy apps and all development must lean OTB. I'm building a solution where I need to have more than one edit form on a list of ...
3
votes
1answer
49 views

How to decide whether to store data in a single list or spread it across multiple lists

We are using SharePoint 2013 On premises version. We have a requirement where I need to store data in SharePoint. On the home page, users need to take actions on the data and the data that is ...
0
votes
1answer
549 views

How to Display View after Crossing Threshhold Limit?

I have a page in which 2 Web Parts are there. One WP is having Date Filter and another WP having List Web Part Displaying Logs of uploading Documents. The List items count have gone above threshold ...