Exceeding List View Threshold in Sharepoint Online

Hi Ted McLaughlin - unfortunately in SPO, even if you're only viewing 30 at a time, there can't be more than 5k in any view. That means filtering out older data, adding more folders or finding a way to categorize with metadata columns. And even if your main view is under 5k, if you have other views in the same list/library that will return more than 5k, the view will break.

---

Ted McLaughlin wrote:

We are in the process of migrating SP on prem to the cloud, and we have a couple Finance libraries that we are moving that are in the 100k to 1.5million range.  Needless to say, that violates the 5,000 list view threshold.

 

What I can't understand is that on prem we have 10,000 set as the list view threshold, and I'm able to easily get into those libraries and click next, next, next, to page through each set of the 30 items that get brought back by the view.  For some reason that doesn't work in SPO.  I have the views set up exactly the same in SPO that we had on prem, but in SPO I just get the list view error and it won't show me any data.

 

I've looked at this page:

https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59?ui=en-US&rs=en-US&ad=US

 

And this one:

https://support.office.com/en-us/article/edit-a-list-view-in-sharepoint-online-15916903-e79a-423f-b4e2-02d37e1ff372

 

But neither of them help.  I'm not trying to display 25k items at once, I just want to bring back 30 at a time and that's it.

---