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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (26,749)