Forum Discussion

GomboKh's avatar
GomboKh
Copper Contributor
Jun 12, 2023

Sharepoint List remove filter button

Hello everyone,

My new list uses a multiple filter on person/group column so users can see only permitted rows.

Now all of a sudden "Clear filters" button appear that completely ruins my goal on the list.

It's not possible to use only "Users only see their created rows" as some request can contain multiple person as reviewer.

How can I remove "Clear filters" button.

I read this is a new feature but I think there should be enabling and disabling option for this.

  • Hi GomboKh;

    perhaps this is a workaround for you:

     
    These filters are not visible if

    • you create a new site page , 
    • add a "Document Library" webpart there and
    • switch that webpart to use your view.
    • Now redirect your users to that site page instead of your view.

    Best Regards,
    Sven

  • Dale_Lombard's avatar
    Dale_Lombard
    Copper Contributor

    Hi GomboKh

    I have figured it out!

    The solution is a lot simpler than custom JSON view formatting or custom CSS.

    I was having a similar problem where I needed to hide the 'Clear Filters' button, even for users with Edit permissions and higher.

     

    I'm not sure if this is a new feature since this post was made but there is a way to disable the 'Clear Filters' button through a combination of Site Permissions and/or List Permissions (depending on your use cases).

     

    Option 1 - Hide the Clear Filters button for a specific Permission Level across all Lists in a Site

    If you go to the Site Permissions of the Site that the list belongs too, then Permission Levels.

     

    Then select the permission level that you want to hide the 'Clear Filters' button from - in my case, the Edit Permission group (ignore my custom permission groups).

     

     

    UNTICK Manage Lists and Save your changes.

    Users with the edit permission will now no longer be able to 'Clear Filters' - as seen in the image below, the Filter 'Personal Items' is selected, however, I can still edit in grid mode (Edit permissions), but there is now no 'Clear Filters' button.

    Now repeat this process for all permissions levels that you do not wish for those users to be able to 'Clear Filters'

     

    Option 2 - Hide the Clear Filters button for a specific Permission Level for a specific list in a Site

    If you just want to apply these changes to a specific SharePoint List in a site and not all SharePoint lists in a site, you will have to disable Inheritance on the SharePoint List and create custom permission levels on the Site level and then associate those custom permission levels to the SharePoint groups in your List permissions.

     

    For example, I have created a custom permission level on my Site called 'Edit items'. I have UNTICKED the Manage Lists option for that permission level.

    Next, in my List Permission Settings, I disabled inheritance from parent (the Site).

    Then I edited the permission level allocated to the Site Members group for my site and set it from 'Edit' to my custom permission level of 'Edit Items'. Then I saved my changes. 

    Essentially, its the same steps as Option 1, but you need to disable inheritance, set up a custom permission level and associate the custom permission level to your desired SharePoint group.

     

    NOTE: I would highly recommend also disabling the permission to allow users to manage personal views. While the users still won't be able to clear the views, it will allow them to create a personal view without the filters from public views (essentially clearing the filter by creating a new personal view).

     

    Hope you find this helpful!

    Let me know if you have any questions, happy to help 🙂

     

  • GomboKh Yes, this is a new feature for SharePoint and Microsoft Lists currently being rolled out by Microsoft.

     

    Unfortunately, currently there is no option for enabling or disabling this feature.

     

    See more details about this in below threads:

    1. List of filters and 'Clear Filters' button shown in SharePoint List View below the list name 
    2. How to hide the applied filters at document library? 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor

    Hi GomboKh;

    perhaps this is a workaround for you:

     
    These filters are not visible if

    • you create a new site page , 
    • add a "Document Library" webpart there and
    • switch that webpart to use your view.
    • Now redirect your users to that site page instead of your view.

    Best Regards,
    Sven

    • GomboKh's avatar
      GomboKh
      Copper Contributor
      SvenSieverding Thanks for the suggestion it works just fine.
      But I hope Microsoft makes the new Filter Pill feature optional in coming updates or at least give us a chance to hide button through JSON formatting.
    • EricW2435's avatar
      EricW2435
      Copper Contributor
      This method used to work but something changed recently (August 2024), and the "view uses filters that you can view and edit here." message appears even with views displayed on pages.
      • Dale_Lombard's avatar
        Dale_Lombard
        Copper Contributor

        Eliot_Cole SvenSieverding The filters only show in the Web part if you do not remove the Manage Lists permission. The screenshot below is of a web part list view of a user with Edit permission but they can not clear the filter on the view of ID = -1 (to hide everything).

         

        Here is the same web part list but with an account that has the Manage List permission (note they can clear the filter)

         

  • SnoopDog's avatar
    SnoopDog
    Brass Contributor
    I can confirm Microsoft started to roll out an adjustment for this feature (checked it on multiple tenants):
    The clear filter option is only visible if you have Edit permission or above on the library/list.

Resources