Jul 25 2021 09:52 AM
Hi SharePoint Community
I have a client need to configure a list view to only show items where a date field contains an entry.
I have seen people in the community advise that the filter should be "not equal to" and leave the value field BLANK when you modify the view.
This DOES NOT WORK once the list hits 5000 items, is this known and why does it not work (technical reason please and is there documentation on this?) as it looks like it does work before the limit is reached or is coming close to it. I'm not sure on when exactly SharePoint decides it doesn't like the quantity of items in a list.
So is there a way to just identify that a column contains a value in SharePoint that anyone is aware of?
Thanks !
Mark
Jul 25 2021 10:18 AM
Jul 25 2021 11:07 AM
Jul 25 2021 11:37 AM
Jul 26 2021 08:51 AM
Yes have done all those recommended approaches.
The main question is - how can you identify a column of any data type contains a value?
And this must work no matter how many items are in the list, documentation says SharePoint can handle up to 30 million rows, what use is this if it constantly falls over after 5000 records?
We can't be getting users to maintain further processes (such as archiving data out of lists etc) due to system constraints.
Is there a MicroSoft expert in this community who can advise on best approach that they have executed themselves before?
Thanks
Mark
Jul 26 2021 11:00 AM
Jul 29 2021 10:37 AM