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
45 views

Get the list of Views those are crossing 5000 items

Recently I have migrated a SP 2013 site to SP Online. Most of the list has items more than 30K to 40K(records). Unfortunately - some of the list has more than 100 and even 200 views! Obviously each ...
0
votes
1answer
45 views

How I can overcome the list view threshold inside our SharePoint online Communication Site document library

I am working on a SharePoint Communication modern site, and we have a document library that contains 8,500 files. Now since the documents are organized inside folders and sub-folders, so we did not ...
1
vote
1answer
49 views

Attempted Operation is prohibited because it exceeds the list view threshold enforced by the administrator

I am copying list items from one list to other list using powershell script.I am getting below error - Exception calling Execute query with zero arguments. The attempted operation is prohibited ...
5
votes
2answers
162 views

Too many lookup columns error - stable list with no new lookups being created or used

Users & 'Full Control' site collection admin are unable to EDIT items. Error message reads: The query cannot be completed because the number of lookup columns it contains exceeds the lookup ...
0
votes
0answers
9 views

How can I upload information in PowerBI from Sharepoint lists of more than 5000 items?

We have a list that has exceeded the threshold of 5000 items. We want to do operations with PowerBI with the elements of that list but we are not able to load the information due to the threshold of ...
0
votes
1answer
42 views

Get single field value for all items from a list having very large number of items

I have a list with about 100K items. There could be gaps in the beginning and in between for SharePoint generated Ids of these items (due to deletions). List items data is live and keep changing. My ...
0
votes
1answer
42 views

How to add more space to save items in list view threshold?

I got warning 4780 items in my list, the limit is 5000. How can I add more space for the list? Could someone help me please? I am using SharePoint Online.
0
votes
1answer
58 views

Can i get the total number of files,folders & size for a sharepoint online document library

Inside sharepoint (on-prem & on-line) we can get the total number of items inside a document library (this includes files and folders) from the site content page. but i have a document library ...
0
votes
0answers
187 views

Get-PnPListItem with Query argument on ODFB raises view threshold Exception

$query = "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='FileLeafRef'/><Value Type='File'>$filename</Value></Eq> </...
1
vote
1answer
19 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
120 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
267 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
260 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
28 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
42 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
25 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
78 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
51 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
21 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
96 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
31 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
43 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
23 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
72 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
47 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
253 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
145 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
266 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
117 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
62 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
337 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
113 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
98 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
155 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
45 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
47 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
33 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
100 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
216 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
41 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
634 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
511 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
63 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
778 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
78 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
548 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
59 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
2answers
2k views

SharePoint List View Filter by [Me]

Wondering if someone can point me in the right direction please. I have a created a custom list view with a filter on a field called 'User' this is a 'Person or group' field setup to show the 'Name' ...
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
416 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 '...