cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Powerapps and Sharepoint Online Permissions

Hey all,

 

I've searching all the threads that talk about this, but I didn't find what I want.

 

I created an app through Powerapps that Adds, Edits, and Deleted rows from a Sharepoint List.

I want to share it with people in my organization.

 

What I did:

  • Shared the app throught Powerapps and gave them 'Can Use'
  • Shared the Sharepoint Site with them and gave them 'Member'

The problem is, the 'Member' cannot see anything, the Galleryview is empty.

But I gave them 'Owner' they can see it and working well.

 

The problem here is:

How can I give the people in my organization access to the Sharepoint Site and not have them edit anything in the Sharepoint Site. In other words, they can only edit the list through Powerapps.

 

Thanks again and again for your great support and wonderful team.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Powerapps and Sharepoint Online Permissions

Go to the settings on the LIST and select Permissions then you can set the specific permissions you want a group or individuals to have on the LIST. Whe you go into {siteurl}/_layouts/15/user.aspx you should see the permissions for the site, you can create a Guest or Read group from the button Create Group at the top, if you dont see that then you may not have site owner permissions and should check that. The permissions levels are maintained at the site collection level, if this is a subsite then you will need to go to the top level and change it there.

View solution in original post

Highlighted
Super User
Super User

Re: Powerapps and Sharepoint Online Permissions

An easy way to troubleshoot the issue would be to add the user to the Members group (should have Edit or Contribute access) and then have the user go to the SharePoint site (Home page) and see if they can navigate to the list that is used in PowerApps. If the user can't get to the site then and the site is a subsite then there is a permissions issue with the root site. If the user can get to the site but can't see the list then permission is with the list (most likely the list has broken inheritance) or if they can get to the list but can't see any items then it might a list item permission issue (broken inheritance) or the list could be using an advance setting that only allows the user to view items they created.



--------------------------------------------------------------------------------
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.

View solution in original post

8 REPLIES 8
Highlighted
Advocate I
Advocate I

Re: Powerapps and Sharepoint Online Permissions

Have you tried giving them Full control of the list? That should give them access to read-write to the list without giving them more than they need at the site level.

Highlighted
Resolver I
Resolver I

Re: Powerapps and Sharepoint Online Permissions

Okay, you meant that I them 'Member' on the site and read-write access? That could work, but I want them to add tasks, and edit a few columns not all of them, and never delete.
Is that doable?
Highlighted
Advocate I
Advocate I

Re: Powerapps and Sharepoint Online Permissions

I mean you give them Guest rights at the SITE level (if you want them to only have read to everything EXCEPT what you choose) and give them contribute rights at the LIST level by disinherieting the permissions from the list in the permissions section. Then you can do the same for permissions in the other LISTS like tasks, etc that they need to be able to add and edit in.

Highlighted
Resolver I
Resolver I

Re: Powerapps and Sharepoint Online Permissions

Okay okay I got you.
But im unable to give Guest I only can give Owner and Member, thats all what i see, and how to give rights to certain people on the List level?
Thanks:)
Highlighted
Advocate I
Advocate I

Re: Powerapps and Sharepoint Online Permissions

Go to the settings on the LIST and select Permissions then you can set the specific permissions you want a group or individuals to have on the LIST. Whe you go into {siteurl}/_layouts/15/user.aspx you should see the permissions for the site, you can create a Guest or Read group from the button Create Group at the top, if you dont see that then you may not have site owner permissions and should check that. The permissions levels are maintained at the site collection level, if this is a subsite then you will need to go to the top level and change it there.

View solution in original post

Highlighted
Super User
Super User

Re: Powerapps and Sharepoint Online Permissions

An easy way to troubleshoot the issue would be to add the user to the Members group (should have Edit or Contribute access) and then have the user go to the SharePoint site (Home page) and see if they can navigate to the list that is used in PowerApps. If the user can't get to the site then and the site is a subsite then there is a permissions issue with the root site. If the user can get to the site but can't see the list then permission is with the list (most likely the list has broken inheritance) or if they can get to the list but can't see any items then it might a list item permission issue (broken inheritance) or the list could be using an advance setting that only allows the user to view items they created.



--------------------------------------------------------------------------------
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.

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Powerapps and Sharepoint Online Permissions

Hey Sababneh,

 

I just recently posted a video explaining how you modify list item permissions from within your PowerApps application using Flow and SP Rest end points.

 

https://youtu.be/T6cC65YwjSI

 

Highlighted
Anonymous
Not applicable

Re: Powerapps and Sharepoint Online Permissions

Hi,

If i understand your question correctly, don't give read level permissions for the list, if you want to submit the data from your powerapps App. You may give read access for site level and give contribute or other equalent permissions for List level so that you can able to submit the data from powerapps.

 

Thanks

Vishnu

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,550)