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

[Australia]

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.

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.

[PowerRanger]

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

[Australia]

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

[PowerRanger]

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

[Australia]

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

[PowerRanger · Accepted solution]

@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

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.

[PowerRanger]

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

[Australia]

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

[PowerRanger]

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