Forum Discussion

Devshan's avatar
Devshan
Copper Contributor
Feb 11, 2024

Hide 'Export to excel' button in both SharePoint List and MS List view

Hi Everyone,   I'm using a custom permission level without the following permission to restrict a few groups of users from exporting list data to Excel.     When users access the Modern Sh...
microsoft lists
Permissions
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Feb 12, 2024

Devshan 

 

Not completely sure why this behavior is completely different for both the products. You can raise a support ticket with Microsoft directly and report this behavior at: Get M365 Support - Online Support 

 

However, you can hide the export to excel button using JSON view formatting in SharePoint. Use JSON like: 

 

{
  "commandBarProps" : {
    "commands": [
      {
        "key": "export",
        "hide": true
      }
    ]
  }
}

 

Note: This hides the button from list view for all users - not possible to hide it based on permissions/access currently. So, if you want this button visible for very few number of users, they can create new personal/private view for them where the button will be visible.

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.

Resources