SOLVED

Stop users from show/hide columns or create more views

%3CLINGO-SUB%20id%3D%22lingo-sub-2695735%22%20slang%3D%22en-US%22%3EStop%20users%20from%20show%2Fhide%20columns%20or%20create%20more%20views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2695735%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3EI%20have%20a%20SharePoint%20site%20with%20Owner%20permission.%3C%2FP%3E%3CP%3EI%20want%20users%20to%20be%20able%20to%20add%2Fview%2Fedit%2Fdelete%20record%20through%20PowerApps%20and%20not%20directly%20through%20SharePoint%20interface.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EI%20have%20given%20users%20EDIT%20and%20CONTRIBUTE%20permission%3A%20The%20PowerApps%20side%20is%20working%20perfectly%3C%2FLI%3E%3CLI%3EI%20have%20hidden%20Lists%20from%20Site%20Contents%3A%20This%20is%20working%20OK%20for%20users%20who%20don't%20know%20the%20URL%3C%2FLI%3E%3CLI%3EI%20have%20created%20only%20one%20view%20-%20All%20Items%20and%20I%20have%20hidden%20columns%3C%2FLI%3E%3C%2FUL%3E%3CP%3EHowever%2C%20this%20is%20not%20preventing%20other%20users%20to%20come%20to%20SharePoint%20(if%20they%20know%20URL%20to%20List)%20and%20then%20using%20Show%2FHide%20option%20to%20display%20the%20data%20columns%2C%20save%20the%20View%20and%20exporting%20everything%20to%20Excel.%20Is%20there%20a%20way%20to%20prevent%20this%2C%20or%20make%20it%20harder%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20I%20can%20modify%20what%26nbsp%3BEDIT%20and%20CONTRIBUTE%20permission%20allow%20to%20the%20user.%20But%20I%20am%20not%20sure%20exactly%20what%20to%20change%2C%20and%20if%20this%20is%20the%20correct%20approach.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2695735%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2696120%22%20slang%3D%22en-US%22%3ERe%3A%20Stop%20users%20from%20show%2Fhide%20columns%20or%20create%20more%20views%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2696120%22%20slang%3D%22en-US%22%3EUnfortunately%20there%20is%20not%20a%20built-in%20way%20to%20avoid%20end-users%20to%20access%20a%20list%2C%20even%20if%20it's%20hidden%2C%20and%20make%20that%20changers.%20However%2C%20a%20custom%20SPFX%20could%20make%20the%20trick%20but%20you%20need%20to%20write%20it%20and%20deploy%20it%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a SharePoint site with Owner permission.

I want users to be able to add/view/edit/delete record through PowerApps and not directly through SharePoint interface.

 

  • I have given users EDIT and CONTRIBUTE permission: The PowerApps side is working perfectly
  • I have hidden Lists from Site Contents: This is working OK for users who don't know the URL
  • I have created only one view - All Items and I have hidden columns

However, this is not preventing other users to come to SharePoint (if they know URL to List) and then using Show/Hide option to display the data columns, save the View and exporting everything to Excel. Is there a way to prevent this, or make it harder?

 

I know how I can modify what EDIT and CONTRIBUTE permission allow to the user. But I am not sure exactly what to change, and if this is the correct approach.

2 Replies
best response confirmed by John Naguib (MVP)
Solution
Unfortunately there is not a built-in way to avoid end-users to access a list, even if it's hidden, and make that changers. However, a custom SPFX could make the trick but you need to write it and deploy it