cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus Post Partisan
Post Partisan

Protect sharepoint list - let users use powerapp but not have access to SP list?

Is there a way to use Sharepoint as my datasource and not be forced to give all users read and write permissions to the sharepoint list?

 

My users need to add data and view data from my datasource.

But i would like to be able to protect the datasource.

It is not enough to just "hide" it so it is "hard" for "most" users to find it.

I need to be able to proove that it is protected and my powerapp is the only way to view and write to it unless being a superadmin.

 

any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Protect sharepoint list - let users use powerapp but not have access to SP list?

Agree with above - also you could create a whole site collection for data storage, and have your lists contained within subsites.

 

Set the permissions for the site collection and the subsites to admin only, then only give users access to the list itself within that subsite - unless they guessed the name of the sharepoint site collection and of the subsite and then of the list, then it will remain intact (and set it to hidden as above and no indexing for search for additional security)


@iAm_ManCat
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!

Thanks!
You and everyone else in the community make it the awesome and welcoming place it is,
keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

3 REPLIES 3
Dual Super User
Dual Super User

Re: Protect sharepoint list - let users use powerapp but not have access to SP list?

@Oskarkuus 

 

PowerApps runs under the context of the logged in user for most data sources and the SharePoint data source connection is one of them. Permissions would have to be granted to users who need to interact (read/write) with the SharePoint list. 

 

One option would be to utilize flow to set item permissions after data is submitted to make the list item data entered as Read only for all users or utilize the item level permissions option for SharePoint lists

However, users would still be able to atleast View the data entered

 

Some options for hiding the SharePoint list would be :-

1) Set the list as a hidden list 

2) Create a default View which shows no items and block users from creating their personal views

3) Set the list search settings to no index (this would ensure the data will not show up in search results)

Super User
Super User

Re: Protect sharepoint list - let users use powerapp but not have access to SP list?

Agree with above - also you could create a whole site collection for data storage, and have your lists contained within subsites.

 

Set the permissions for the site collection and the subsites to admin only, then only give users access to the list itself within that subsite - unless they guessed the name of the sharepoint site collection and of the subsite and then of the list, then it will remain intact (and set it to hidden as above and no indexing for search for additional security)


@iAm_ManCat
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!

Thanks!
You and everyone else in the community make it the awesome and welcoming place it is,
keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


View solution in original post

Highlighted
Community Support
Community Support

Re: Protect sharepoint list - let users use powerapp but not have access to SP list?

Hi @Oskarkuus ,

Do you want the end users to use your app to read/write data from/back to your SP list, but do not have access to your SP list directly?

 

If you want the end users to use your shared app to read/write data from/back to your SP list, these users must have access to your SP list data source, otherwise, they could not read data from your SP list or write data back to your SP list through this shared app.

Note: The data access permission within a canvas app inherits permissions from the data source itself.

 

If you want the end users to use your app to read/write data from/back to your SP list, but do not have access to your SP list directly, I afraid that there is no way to achieve your needs in PowerApps currently.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,744)