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

PowerApps and Sharepoint List access permission

Hello,

 

I wonder is a user submit a form via PowerApps, whose data is stored in a SharePoint List. Will the user then automatically be granted permission to view the SharePoint List, assumming that the user don't have access to the SharePoint List in the first place?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi anguyen,

 

Before you share an app that is based on SharePoint list, you need to share the list with users with Edit or View permission. Otherwise, shared user won’t be able to access or submit data to the data source.

 

Please check reference documentations about sharing app and resources:
https://powerapps.microsoft.com/en-us/tutorials/share-app/
https://powerapps.microsoft.com/en-us/tutorials/share-app-resources/

 

Best regards,
Mabel Mao

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

View solution in original post

6 REPLIES 6
v-yamao-msft
Community Support
Community Support

Hi anguyen,

 

Before you share an app that is based on SharePoint list, you need to share the list with users with Edit or View permission. Otherwise, shared user won’t be able to access or submit data to the data source.

 

Please check reference documentations about sharing app and resources:
https://powerapps.microsoft.com/en-us/tutorials/share-app/
https://powerapps.microsoft.com/en-us/tutorials/share-app-resources/

 

Best regards,
Mabel Mao

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

View solution in original post

ChinoDoesStuff
Advocate II
Advocate II

Hey Anguyen,

 

I recently posted a video explaining how to set item level security on List Items from within your PowerApp using SP Rest API.

 

https://youtu.be/T6cC65YwjSI

@ChinoDoesStuffthank you so much!!  This video is exactly what I needed.  If I have two approvers do I have to do the steps over again for each?

Hi Amy...

 

No you shouldn't have to repeat each step, just make sure you include each user that is required for the add user step.

I created a powerapp and made it available to all tenant users to do a quiz which saves data to a sp list.

I granted the list contribute permissions for all users. Users can store data on the list but below request pops up the first time they open the app.

I tried with different permission levels on the list but nothing changes.

Can I solve it easily without any complicated flows?

 

MicrosoftTeams-image (1).png

 

 

Anonymous
Not applicable

If you are an O365 Admin, you can disable this popup. https://www.anupams.net/suppress-user-consent-popup-in-powerapps/

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,406)