Approaches we have to hide or disable the Export functionality inside SharePoint online custom list?

Question

We have a custom list inside our SharePoint online modern communication site. And our customer wants to hide or disable the Export option, to prevent users from exporting all the data and misuse it by mistake.

So what are the approaches we have to disable or hide the export option inside our custom list? If the above is possible then can we also do the following: -

Can this be done to one custom list only?

Can we prevent the export for user Read-Only permission while allow it if the user have contribute permission or more?

Answer 1

@john john ,

Per my test, Custom Permission Level without Client Integration Features can not use the export function, so we can do this based on permissions and custom list only.

Go to the list settings>Stop inheriting permission, then grant ReadWithoutClient permission to specific user as shown below:

After that, the user will not able to see export button in custom list:

Of course, ContributeWithoutClient or more(such as FullControlWithoutClient)also cannot use the export option.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---

Answer 2

Is is working for Excel but not for Export to Power BI...