cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jsalaz1989
Helper II
Helper II

SubmitForm doesn't work for users with View access in a list

Hello,

 

I wanted to confirm something about the permissions required to write from a power apps form to a SharePoint/Microsoft list. In this list, I have given view access to a user in my organization but, even though he can submit the form without any errors, the item is not created in the list.

 

However, if instead I give the user edit access, he is able to create the item via de form. This worries me because each user of the form should be able to create the list items, but not update or delete any other items.

 

I wanted to confirm that, in order for a user to add an item to a list, he/she must have edit access to that list. In other words, I want to confirm if a user with only view access cannot create list items through the power app.

 

 

Thanks for your help

 

 

P.S. The same thing happens if instead of SubmitForm() I use Patch().

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Resident Rockstar
Resident Rockstar

For a user to add items to a SharePoint list via Power Apps, they user will require Add permissions.

The SharePoint permissions page show the following permissions that we can apply to a list:

ekarim2020_3-1625913427843.png

Note the Contribute and Edit permissions.

Do you think using Advance Settings and restricting users to viewing and editing only the items they have created would help?

 

ekarim2020_1-1625912779326.png

Ellis

View solution in original post

1 REPLY 1
ekarim2020
Resident Rockstar
Resident Rockstar

For a user to add items to a SharePoint list via Power Apps, they user will require Add permissions.

The SharePoint permissions page show the following permissions that we can apply to a list:

ekarim2020_3-1625913427843.png

Note the Contribute and Edit permissions.

Do you think using Advance Settings and restricting users to viewing and editing only the items they have created would help?

 

ekarim2020_1-1625912779326.png

Ellis

View solution in original post

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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,491)