Questions tagged [large-lists]
Lists are the storage mechanism in the SharePoint platform.when you have the more than 5k items in your list the performance of the list or library may begin to slow down or adversely affect other areas of the site.
57
questions
0
votes
0
answers
140
views
Export to excel return "You do not have permission to view the entire list because it is larger than the list view threshold enforced by the admin""
We have a list view which contain less than 400 items, the list it self contain 33,000 items. Now we have a list view which have this filtering and sorting based on indexed columns (all the fields ...
0
votes
2
answers
66
views
Large SharePoint lists - threshold limit
How big of a problem is it having large lists with hundreds of thousands of items and views that grab 'em all out with no filtering what so ever?
The magic number of 5000 items per view circulating ...
- 47
1
vote
2
answers
40
views
Power App that lets users search for items containing word "urgent" in the title
I have a list with 2 million items. I need to build Power App that lets users search for the items containing word "urgent" in the title. The word urgent can appear anywhere in the title.
Is ...
- 9,547
0
votes
2
answers
78
views
Large document library
My client uses SharePoint 2016 on prem. The last couple of months they started using third party software that send client files to one SharePoint library. For each client, a sub folder is created in ...
- 318
0
votes
2
answers
254
views
Ability to filter and sort large SharePoint list using UN-indexed fields
I have a SharePoint online site collection, which contain a custom list, which contain around 51,000 items, as follow:-
and currently the list contain these 3 indexes :-
When i access the main list ...
0
votes
1
answer
70
views
Performance on using hierarchical tasks in a huge task list
We combined multiple task lists into one to overcome different difficulties. This resulted in a task list with about 90.000 items.
Upon opening a hierarchical task view with an additional filter on an ...
- 91
3
votes
0
answers
606
views
Difference between camlQuery.AllowIncrementalResults=true and camlQuery.AllowIncrementalResults=false?
My aim is to get all items from a SharePoint List (>5000 items). I have used the standard pagination based approach and it is working fine.
ListItemCollectionPosition position=null;
do{
...
1
vote
2
answers
2k
views
CSOM Caml query get only root level folders in document library(paginated response)
Try to ignore some of the ugly if statements :D. I am very new to CSOM and caml. Is it possible to write Caml statement that returns the Folders in the Root of the document library only? Apologies ...
0
votes
1
answer
1k
views
Filtering large list (more than 5K items) using two columns with REST API
I have a list which has more than 5K items in it and I need to filter it by using multiple columns. Below is the challenge that I am facing.
Scenario 1: Below REST API fails with Microsoft.SharePoint....
- 1,892
0
votes
1
answer
220
views
SharePoint CSOM query against concrete subfolder is not working with RowLimit when thresold is reached [duplicate]
Can you please help with the following question. I have a document library with a lot of documents (>5000) which are organized in subfolders. I have to query all documents in subfolder. I use this ...
0
votes
1
answer
142
views
Adding a calculated column to a Large List -- how much time it will take?
I have this question because we have a Production deployment and we need to update some lists with about 1 million items stored on them
The calculated field formula is very simple :take 1 field and ...
- 245
0
votes
1
answer
829
views
Upload large list (2 mln records) to SharePoint Online, from Access *.mdb
I try to migrate records from Access database to SharePoint list (about 2 millions records). I go to "External" tab, then "More.." and there is "Export to SharePoint list". It failed after about 15'...
- 1,623
0
votes
3
answers
687
views
Export table to exisiting sharepoint list from excel
Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
- 139
1
vote
0
answers
305
views
Filtered, large list exporting
I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
- 31
0
votes
3
answers
55
views
A large amount of items approach in SharePoint
One of the customers decided to migrate his solution to SharePoint. As far as I know, there would be an issue with the SharePoint threshold limitations.
There is like 20k items to migrate to primary ...
- 17
2
votes
1
answer
87
views
Sharepoint large list filtering
Currently in Sharepiont 2010.
I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
- 31
0
votes
2
answers
3k
views
Querying Very large list using Rest API - advice required
We have a list, the items will be added everyday by scheduled job.
The number of items varies around 5000 to 12000 every day..
The list has columns like:
Country: Lookup
City: Lookup
StartDate: ...
- 493
0
votes
0
answers
69
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
3
answers
2k
views
Lookup column agains list with more than 5000 posts
I am new to SP online.
This is about a lookup column that displays data from another list which is currently exceeds the 5000 items limit?
Any easy solution as I dont have much programming ...
1
vote
1
answer
573
views
Export multiple lists into a single CSV file
I have a requirement to fetch 2 large lists and merge data into a single CSV file. Suppose Lists are as below :
List A
Column1
Data1
Data2
List B
Column2
Data3
Data4
Then Data should be displayed ...
- 828
1
vote
2
answers
149
views
Add large sharepoint list to sharepoint 2013 site
I have SharePoint list with big number of items (13879 items).
I saved it with content, download list template and change GUID in manifest.xml file.
after I add it to .cab and renamed to .stp file ...
- 113
1
vote
1
answer
307
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 ...
- 774
1
vote
1
answer
2k
views
Problems using office365 Sharepoint Lists as backend for MS Access 2016
i'm completely new to sharepoint.
I had a fairly complex Access 2016 database where there was a "backend" Access database with 15 tables, a Access "admin" frontend with lots of queries for reporting, ...
- 119
1
vote
2
answers
178
views
Record Center in SharePoint Online Limits
We are transferring 3 million archived invoices from SFTP server to our first-ever SharePoint Online Record Center. Moving the files into SharePoint is not the problem, getting the files folder-...
- 21
1
vote
1
answer
140
views
Indexing SharePoint 2013 List Columns
I have sharepoint list which has more than 40,000 item. Now the performance was very slow, So I planned to try Indexing to improve performances.
When I try to add the Indexing it's returning the ...
0
votes
0
answers
33
views
SharePoint List Not Working As Webpart
I am trying to upload a webpart view of a list with over 1,000 items in it. When I upload the webpart from my site collection gallery, it appears as the whole list. When I go into webpart properties ...
- 229
0
votes
1
answer
1k
views
How to handle Excel 2013 data queries for large lists (>5,000 items) in SharePoint online O365?
I would be interested if anyone has a suggestion for handling this. I am working in Office 365 (but with Excel 2013), so I can't change any of the SharePoint throttling behavior for this list.
...
0
votes
2
answers
3k
views
Filtering Large Lists with AND and OR operators
I have a larger list of data including more than 5000 items. Users create entries and assign them to managers for review. Managers action the items and users re-review. I am using SharePoint 2013 ...
- 61
2
votes
0
answers
54
views
What causes the list alert option on updates on items within a view to not appear?
I have multiple large lists, and I'm able to specify a view to filter my alerts on both one of the smallest lists and the largest of those lists (6k and 50k items). The smallest list has 5.35k items, ...
- 739
0
votes
1
answer
24
views
SharePoint2010 to SharePoint 2013 - just the lists and content types
Hi I'm trying to upgrade my SP2010 site to SP2013 but ideally I just want to take the 'content' of the site so, documents, lists, content types and perhaps user permissions (although I could recreate ...
- 187
1
vote
1
answer
361
views
Request timeout error large list SharePoint 2010
I have one custom list which contains appox 10500000 data and it was working fine. but after that it throws timeout error.
so what we did is we trim 20 Lakhs data from that list so list has now ...
1
vote
0
answers
100
views
Using Cascading Dropdown Fields with a Large List
I am trying to find an OOTB method to use to accomplish this task.
I have a lookup field (Vendor #) that needs to pick up the matching values whenever a Vendor is selected from its dropdown lookup.
...
- 787
0
votes
1
answer
165
views
SharePoint Save as Template not working
So I have a list, where I want to be able to copy an item between different lists. My plan was to use sharepoint2013 and save the list as a template, and then use that list as a template for my others....
- 163
0
votes
1
answer
488
views
O365\SharePoint rest call on Large list - checked out (recursive)
Wondering if anyone has a suggestion for querying a large list > 5000 items to get all the checked out files (recursively).
Can I query the search index for this?
Here's what I've done so far ...
- 61
1
vote
0
answers
979
views
SharePoint Online: Microsoft.SharePoint.Client.ServerException: Ending value cannot be less than starting value
I am using a Windows Forms Application to create a massive amount of items in various lists inside a SharePoint Online site based on information that the application gets from a JSON file. The ...
- 11
0
votes
1
answer
1k
views
Large list error filtering with indexed column SP 2013
I have a custom list that has over 24k items and utilizes lookup columns. We have indexed columns and have been working with filtering to allow different views to manage the list for a few months now. ...
- 11
0
votes
1
answer
47
views
Link two existing lists
I'm working with SharePoint 2013 and recently take over and learn how to do stuff in it, and had to migrate some old project databases to sharepoint. I currently have our old databases uploaded in an ...
- 3
2
votes
3
answers
4k
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 ...
- 21
3
votes
1
answer
64
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 ...
1
vote
1
answer
129
views
Will there be performance issues if a list have 50 columns in a list?
Depending on requirements amount of columns in a list can differ.
There has been discussions on other websits regarding performance and amount of columns.
There is usually three common options:
Have ...
- 411
1
vote
1
answer
992
views
Automate Moving Items into Folders in a List [duplicate]
When I have large lists or new ones that could become large lists I would like to create an automated way to move items into folders to help with performance on the root level of the list.
For a ...
- 1,282
4
votes
4
answers
728
views
Store 2,500,000 records SharePoint
I want to keep the records of registered user for course registration. There are maximum 100,000 users, 1 user can registered 25 courses.
Which means the maximum records can be 2,500,000. One item ...
- 766
0
votes
2
answers
1k
views
How to get more than 5000 items in list without enabled throttling?
I'm trying to work with large list but every time I do an operation on a list I have an exception because I have more than 5000 items in my list.
Microsoft.SharePoint.SPQueryThrottledException
If I ...
- 963
0
votes
1
answer
553
views
SPServices GetListItems not working with large list
I am trying to get the last 100 items entered into a list with 13000 items in it.
I can pull items from another list on the same site fine but for this list it doesn't seem to get into the ...
- 23
2
votes
1
answer
80
views
Opinions/advice on List Sizes and using SharePoint Online to store data
My company has a requirement for field personnel to complete a variety of paper forms in the the field, in areas of little or no connectivity.
We have identified a mobile data collection ...
- 21
3
votes
0
answers
195
views
Efficient way to Query Large lists to get little data
I am querying a large list with around 25000 items but the data returned is quite small, like 20 items top.
Can you please let me know the best practices to do so, for e.g. orderby Indexed column.
I ...
- 4,474
3
votes
1
answer
385
views
Filtering a large list by Month/Year
I've got a large list (85-100k items) in SP2013 that the user wants to filter by month and year (each month of data is 2,500-4,000K items), preferably selecting from drop downs. (Clarification: ...
- 263
1
vote
0
answers
71
views
Speed up indexing a column when rows > 5000
I've got a large list (>75,000 items, 41 columns) and therefore have to follow all the rules for handling large lists.
If a new column needs to be filtered on (and therefore needs to be indexed) ...
- 263
1
vote
0
answers
39
views
Query on how to manage large lists
I'm facing a dilemma on how to best use SharePoint 2013. I have a requirement of creating a solution that will be used around 600 users. Each user will create at least 1 task so each day there will be ...
- 415
1
vote
3
answers
825
views
Delete one column from large list
I have a column in a list of over 15,000 items. The column we want to delete was recently created, and we were going to populate it/backfill the values, but then decided to split it into 3 fields (...
- 309