cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
considerITman
Frequent Visitor

Separating permission scopes between data source (SP) and PowerApps

Hi folks,

 

I’m building an App that interacts with a SharePoint list.

I need to make sure that users interact with the list through the App exclusively. My first thought was to use a service account for the connection to SP and set the list permissions accordingly (edit for the service account, no permissions for the users) – since this is how I would have done it in the past. It seems like there is no way to action the connection to SP in a different user context than the one running the app.

So far the only idea I had was to use a flow to do the dirty work using a different account – However this is not a great solution. Users need to interact with multiple items in a short time span. This makes for a timing issue since the values would have to be copied around and the flow takes some time to execute.

Has anyone been able to do something similar?

 

Thanks, take care,

Alex

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

You could try giving the users the permissions they would need in the SharePoint list to allow the SharePoint connector in PowerApps to its things. Then hide the list and turn off the search index for the list or site. This would make it very unlucky (but not impossible) that a user could find the list and update it.

 

Could also harden this approach by making the default view (and the only view) show nothing and make sure the users permission don't include the ability to create public of private views. 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Permission by omission. 

I'll have to keep looking, but thanks for your suggestion.
I might go this way until I find something more robust.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,536)