Forum Discussion

Deenadayalan V's avatar
Deenadayalan V
Brass Contributor
Jan 04, 2018

SPO Views - Filter Pane - How it is working?

Feel like the views that are created in SPO is not behaving consistently. 

We have a large document library with 3 million items. Created multiple views using "Folders" and various "Filters" as recommended https://support.office.com/en-us/article/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59 and https://support.office.com/en-us/article/Use-filtering-to-modify-a-SharePoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4

 

Configured the document library (using Metadata Navigation settings) to use "Modifed" as Filter.

We have set of documents that are older than 3 years and counts upto 30. So created a view filtering based on the name of the document. But the view is not returning any rows. 

Also the Filter Pane is also not showing up.

 

I don't want to add a date filter with [Today]-1095 as it will prevent any new files that's added from showing in the result. Instead added a filter that filters on the name that will return those 30 files. But still it doesn't show up. I am trying to understand whey the result set which is less than 5000 threshold limit doesn't show up? What kind of throttling is happening here?

 

Also when I first time visit this view, the "Filter" icon shows up. If I click again, it disappears and after that Filter icon never appears. I have to come to "All Documents" view again to get back the filter.

 

 

And the frequent updates to how the views functioning is giving hard time and consuming lot of training efforts with the users. 

8 Replies

  • I assume you use the classic mode for the document library as you still use Metadata navigation. Is it possible for you to use the modern experience for the library? This way you could use the new Filter Pane and pin the columns to filter on top.

    • Deenadayalan V's avatar
      Deenadayalan V
      Brass Contributor

      Thanks Schouten. I have configured the Meta Data Navigation since the Filter Pane doesn't show up for certain views. We are using Modern Experience only. The filter pane always doesn't show up.

      • Robert Schouten's avatar
        Robert Schouten
        MVP

        Ok great you are using the Modern Experience! Can you ensure the columns you filter on are indexed?

         

        Miceile Barrett as program manager on the Filter pane. Can you shine a light on this?

  • Regarding "[Today]-3 years" is to be written as "[Today]-1095" where 1095 is 3 x 365 days. Hope this helps a little. Kind regards, John
    • Deenadayalan V's avatar
      Deenadayalan V
      Brass Contributor

      Thanks. I may need to edit the post. The problem is not with adding a filter like that. But I feel it prevents the view in showing new files, say for example if I add a new file today.