Forum Discussion
Searching for Items in SharePoint Lists with over 5000 Items
I've tested this, and was disappointed to learn that if you run a query within a view, results show below the search box, but the list view results are limited to those within the list.
If I created a list with names of fruits and vegetables, and created a view for those beginning with 'A' and searched for 'Banana' it would not appear on the list when I completed the search, but would appear below the search box as I was typing.
If we can have 30,000,000 items, but we can only search for 5,000 at a time, what is the point of having so many items?!
Should I stop using SharePoint lists for storing data and only use them for document libraries?
Without my AWA, I feel helpless.
Even Document libraries with larger than 5000 documents have same issues. I have been struggling with this issue for quite some time, Microsoft support says this is a limitation from browsers and they can't handle loading so many records, but that is no excuse for not being able to fetch a single entry from a list when you search for it. I mean when i search for items I expect the search runs in the database not in a cached list within my browser.
hopefully Microsoft have a solution coming out for this or a search feature replacement.
Hello,
Any updates on this? i feel your pain!
I have the same problem. I had previously created a call center via AWA and our lists will always exceed 5000 items. Got us through 4 years with ease!
There doesn't seem to be a true way to replicate the functionality of AWA even through workflows or views, forcing me to create customized share point lists and use a connected desktop Access database to manage the look up's, searches, mass updates and reports. This is a lot of hand holding ... and don't even get me started on Power App's...
Sharepoint is great in collaborating, last month we managed to utilize SharePoint as a Call Center to make roughly 50 k calls, but that meant uploading multiple SharePoint Lists due to the 5k limit view and using Access Desktop to contain a master list that is updated using a macro within Access.
I may opt to create a linked Access Database on a shared network to manage searches and reports...
