cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Australia
Post Patron
Post Patron

Network error when using Patch function: You don't have permissions to edit this row.

Hi PA veterans,

 

I created a Powerapp for my colleagues to fill out a questionnaire. A button called 'Submit' submits (patch) all answers and saves to a SharePoint list. However, my colleagues are getting this red error message as below.

PA issue_2.jpg

 

The current list permission for users are: Users (everyone except for external users) : Read

 

May I know how can I set up a customised permission so that the users can write to the list but not actually access the list and see the data?

 

Thank you.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Australia That is something completely different. If you want to prevent users from seeing other users data, this can be done by using Item-Level Permission

 

Go to List Settings - Advanced Settings

PowerRanger_0-1644560169361.png

By Default users can read and edit all. Change it like above and they won't be able to read or edit other items not created by them.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

8 REPLIES 8
PowerRanger
Resident Rockstar
Resident Rockstar

@Australia in order to Patch a datasource the users Do need to have write permission for the underlying data. Powerapps always runs in user context and there is no way to delegate permission.

 

If you do not want your users to have write permission the only way is using power automate. 

 

Option 1

User can only read data, any changes they make will be patched into a different table. A workflow Listens to that table and Updates the original data source. The workflow has to use a connection with write access to the original data

 

Option 2

More or less the same. But you would Call a flow from the App, pass the data to this flow, Call a child flow which make the Update. 

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

@PowerRanger hello again PowerRanger.

Thanks for the reply.

I am happy for my users to have Edit access to the list so that data can be saved to the list. However, I do not want them to be able to view the SharePoint list even if they navigate directly to it.

@Australia Well, that is not possible. If they write access - then they have access to the list. That is by design.

 

There are several ways how you could try to prevent users of going to the list directly.

 

1. You can hide the list from Site Contents using powershell

2. create views so they can't see any data

 

and there are more....

 

But this is all about trying to hide information from the user. This is no security! If they know how to get to the list they will be able to get there. Thats because PowerApps runs in the user context. I would love to have the feature that PowerApps may run with its own application permission but that is not yet possible.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up. 




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks again @PowerRanger .  

Make sense but this situation actually poses a huge privacy breach for us now . It means that our users can navigate themselves to the List and see all other users' data... 😞 

@Australia That is something completely different. If you want to prevent users from seeing other users data, this can be done by using Item-Level Permission

 

Go to List Settings - Advanced Settings

PowerRanger_0-1644560169361.png

By Default users can read and edit all. Change it like above and they won't be able to read or edit other items not created by them.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.
PowerRanger
Resident Rockstar
Resident Rockstar

@Australia This is now true security. This would also work with powerapps. What I mean is that you would not have to create A Filter like Filter(dataSource,CreatedBy.Email = User().Email) because users wouldn't get any other data anyway.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

 




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.
Australia
Post Patron
Post Patron

@PowerRanger Wow, maybe that's exactly what I need. I am terribly sorry but where do I see these settings?

@Australia

Navigate to your list. On the upper right side click the gear icon. Select List Settings...

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.




​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

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