Hello SharePoint Community!
So I have a Document Library with more than 5,000 documents in it. That's fine, All the documents have enough meta data that I can create good views to shorten the queried list well under the thresh-hold.
I have one such view, that is my "Quick Edit" view. It only shows documents that are missing a value from a lookup relationship from another List on the site. If this value is empty, the document shows up in this view for Quick Editing.
Now the view works fine, in the modern SharePoint Exp, BUT when you want to perform a "Quick Edit" the view understandably switches to classic for this. Issue is that once it does that I get the:
This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.
I even get this message by switching to the classic exp, and selecting the view from the view list in classic. Very frustrating.
Is there something I am missing?
Thanks in advance!
EDIT:
After "Indexing" the Lookup Column (with no improvement), I ended up manually entering the metadata for my "Quick Edit" view... Not so quickly I might add. And even with the empty view, If I switch to classic / Click "Quick Edit" I get the thresh-hold error... So yeah, I don't get it, the view should be empty. But classic does not register that. Think there are 5000+ results.