Stack Exchange Network

Stack Exchange network consists of 175 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

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.

0
votes
2answers
23 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: ...
0
votes
0answers
20 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
2answers
89 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
1answer
54 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 ...
1
vote
2answers
49 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 ...
1
vote
1answer
55 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
64 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, ...
0
votes
1answer
36 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-...
1
vote
1answer
70 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
0answers
15 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 ...
0
votes
1answer
113 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
2answers
662 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 ...
0
votes
0answers
14 views

Large amount of data needed for custom form/sharepoint UI…What are my options?

Unfortunately, we do not have access to a server and need to utilize Sharepoint 2013 Online functionality for storing large amounts of data. To put it in perspective we are needing data for an entire ...
0
votes
0answers
17 views

Combined Data Sources and Displaying List & Library Data

We are utilizing SharePoint 2010 Foundation. Here is what we have: I have a document list. Each document has already completed a workflow with associated tasks that are held in a separate list. These ...
1
vote
0answers
21 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, ...
0
votes
1answer
22 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 ...
1
vote
1answer
169 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
0answers
68 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. ...
0
votes
1answer
97 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....
0
votes
1answer
318 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 ...
1
vote
0answers
484 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 ...
0
votes
1answer
606 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. ...
0
votes
1answer
25 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 ...
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 ...
3
votes
1answer
51 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
1answer
71 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 ...
1
vote
1answer
662 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 ...
4
votes
4answers
525 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 ...
0
votes
1answer
462 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 ...
0
votes
1answer
411 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 ...
2
votes
1answer
58 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 ...
3
votes
0answers
150 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 ...
3
votes
1answer
150 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: ...
1
vote
0answers
56 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) ...
1
vote
0answers
33 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 ...
1
vote
2answers
406 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 (...
1
vote
1answer
439 views

Sharepoint large document library - best practise

I work for a company that creates software that interfaces with Sharepoint through web services (this is due to the backwards compatibility needed for Sharepoint 2007). How we setup sharepoint to ...
1
vote
1answer
240 views

Large List in SharePoint Online for Custom Reports?

I can't seem to find an explicit msdn article that mentions SharePoint Online can store up to 30,000,000 list items in a List. I saw that there is an article for the List View Threshold but it does ...
3
votes
3answers
2k views

I want to take backup automatically of a SharePoint online list as excel file every day

I have a SharePoint online list with more than 9000 items and the list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the document ...
3
votes
2answers
5k views

List exceeds threshold. query large lists

I have a list that exceeds the 5000 threshold. total is 16013. Is it possible to query lists of this size. I can get all of contents with no query in batch using query..ListItemCollectionPosition ...
0
votes
2answers
507 views

How to query large list and retrieve one field of all items?

Image a list with i.e. 20.000 list items. All items have the field ContainerId (indexed). I now want to retrieve all ContainerIds to do other stuff with those. SPQuery is limited to a maximum of 2000 ...
0
votes
1answer
294 views

How to avoid large list error when modifying URL filtered view

I have run into a problem with SharePoint that is frustrating my users to no end. I have a large list (>5000 rows) that users can arrive at by clicking links formatted like this http://my.farm.com/...
0
votes
2answers
157 views

more than 350000 page within same sharepoint 2013 library

I want to use SharePoint to build news site, this site will publish more than 200 page every day, and there are around 350000 archive news required to migrate to this site. And there are a lot of ...