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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

Query for items with custom permissions

Is there an efficient way to query for items that have custom permissions in a large SharePoint Online list or library? The current approach I'm using is to iterate over each item, retrieve the ...
user avatar
0 votes
0 answers
14 views

Loop thorugh a collection and issue seperate Lookup instead of using one Find and get delegation warning

I have 2 SharePoint lists:- Task list .. with these fields:- ID Title PeopleWork list.. with these fields:- ID TaskID .. this should store the Task ID from the Task list in numeric format ...
user avatar
  • 2,224
0 votes
0 answers
7 views

How much sense makes to store simple data in a Sharepoint list

I have to choose a simple and fast way to store data (person names, email and a couple of text fields) in a list. My idea is a Sharepoint online - since my company is already using it. We are talking ...
user avatar
  • 593
0 votes
0 answers
5 views

Manage ManyT-Many relation between Tasks & Projects SharePoint lists; Storing the ProjectsIDs inside the Tasks field OR by creating a seperate list

I have 2 SharePoint online lists:- Task Project where a task can be associated with zero,one or multiple projects. Now I have 2 approaches to store this Many To Many relation between the Task and ...
user avatar
  • 2,224
0 votes
0 answers
6 views

create and manage the relation between Project and Task lists inside SharePoint and Power Apps. where a task can be assigned to multiple projects

I have 2 SharePoint online lists:- Task Project where a task can be associated with zero,one or multiple projects Now if i were building this according to the book, i will create the relation ...
user avatar
  • 2,224
0 votes
2 answers
36 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 ...
user avatar
1 vote
2 answers
34 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 ...
user avatar
0 votes
0 answers
28 views

Power App Form that connects to a list with 2 million as a lookup

I have a large SharePoint list. It contains 2 million company names from across the world. I have a Power Apps form that needs to connect to this list. I need a text box field that let's me select one ...
user avatar
0 votes
0 answers
15 views

limitation on the Lookup field if the list which is been referenced exceed certain number of items

I have a Parent SharePoint online list which is been referenced by 2 lists using Lookup fields. now the parent SharePoint list has 174858++ items as follow:- and when i create new items inside the ...
user avatar
  • 2,224
0 votes
2 answers
51 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 ...
user avatar
  • 319
0 votes
2 answers
48 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 ...
user avatar
  • 2,224
0 votes
1 answer
31 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 ...
user avatar
  • 91
3 votes
0 answers
389 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{ ...
user avatar
1 vote
2 answers
850 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 ...
user avatar
0 votes
1 answer
375 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....
user avatar
  • 1,842
0 votes
1 answer
133 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 ...
user avatar
0 votes
1 answer
108 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 ...
user avatar
  • 235
0 votes
1 answer
487 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'...
user avatar
  • 1,581
0 votes
3 answers
372 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?
user avatar
  • 87
1 vote
0 answers
300 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 ...
user avatar
  • 31
0 votes
3 answers
46 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 ...
user avatar
2 votes
1 answer
82 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 ...
user avatar
  • 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: ...
user avatar
  • 473
0 votes
0 answers
54 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 ...
user avatar
0 votes
3 answers
1k 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 ...
user avatar
1 vote
1 answer
399 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 ...
user avatar
  • 808
1 vote
2 answers
123 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 ...
user avatar
1 vote
1 answer
273 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 ...
user avatar
  • 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, ...
user avatar
1 vote
2 answers
154 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-...
user avatar
1 vote
1 answer
134 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 ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
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. ...
user avatar
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 ...
user avatar
2 votes
0 answers
51 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, ...
user avatar
  • 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 ...
user avatar
1 vote
1 answer
344 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 ...
user avatar
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. ...
user avatar
  • 787
0 votes
1 answer
151 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....
user avatar
  • 163
0 votes
1 answer
467 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 ...
user avatar
  • 61
1 vote
0 answers
859 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 ...
user avatar
  • 11
0 votes
1 answer
998 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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
3 votes
1 answer
61 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 ...
user avatar
1 vote
1 answer
99 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 ...
user avatar
  • 411
1 vote
1 answer
948 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 ...
user avatar
  • 1,282
4 votes
4 answers
702 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 ...
user avatar
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 ...
user avatar
0 votes
1 answer
526 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 ...
user avatar
  • 23