Forum Discussion
SharePoint - Filter stacking
Hi, I have a few clarifications regarding your setup:
When you mention Document ID, are you referring to:
- The SharePoint Document ID feature (enabled at the Site Collection level),
- OR A custom column, or
- OR The out-of-the-box ID column in the library/list?
- How are you constructing the URL for filtering?
- Is it manually entered?
- Generated through some automation (Power Automate, custom approach, etc.)?
- Or created using JSON column formatting?
- This hyperlink column - is the intent to:
- Open a specific document directly, or
- Navigate to the document library filtered to show one or more documents (based on the ID)?
Understanding this will help identify why multiple filter values are being applied or stacked.
Virendrak,
Thank you so much for your quick response!
I spent some additional time reviewing this and was able to realize that someone had gone into the filters and created additional filters that were stacking/blocking my DocLink URL's. I removed those and it stabilized the library and the filters! I also locked the list down as well!
The ID column is custom single text field, the URL is pulling from a library where all the documents are uploaded to, and the hyperlink is designed to open a specific set of documents all that have the specific ID number, so it might be 10, 15, 20 associated documents, so the later "Navigate to the document library filtered to show one or more documents based on the ID. Working as intended now.
I do have another filtering dilemma.
- I have a filter on SP list that has 9,944 items; the filter is set to show items from today or later with a status of Accept; grouped by the start date; the start date is an indexed column and so is the status colum
- I have noticed that the label on the grouping, for example, Start Date: 6/29/2026 (10) shows this label, but the actual items for this start date within the list is much more, in this example 41 actual items with a 6/29/26 Start Date
- I also have the grouping set to "collapse", but the items are "expanded" instead, they really should show like the following exampe:
- Start Date: 6/10/2026 (15)
- Start Date: 6/22/2026 (45)
- Start Date: 6/27/2026 (11)
- I do not have a sort set on the filter
Why would the label not show the true item count? I also can't tell the reasoning as to why the filter goes from May 31, 2026 to the last filter for August 24, 2026, so I guess a 90-day spread. I'll have to dig more into this to see why it's only showing through August since it's saying from today or later, how does it know where to stop on the "later". Is this a SharePoint list filter setting?
Again, thank you for your time and help.
SharePoint behaves differently once you exceed the 5,000 item threshold. Since your list has close to 10K items, I’d recommend creating multiple views so that each query operates on a smaller dataset. For example, you could segment the data by year or another logical filter to keep results within the threshold limits.
If you need to export items, try exporting from a view without grouping or complex filters applied (a flat view). Or use PowerShell script....
Also, if you have access to Power BI, it would be a better option for reporting and handling larger datasets efficiently.