Answered

Network error when using patch function. You don't have permission to create this row

(1) Share

Report

Posted on by CampoGu

Hello!

I have created an form app that the users submit data and a sharepoint list is filled with that info. I have just set a simple "submitform" function on submit button. So, we have a dynamic group created (already with Security enabled), so that I don't have to mannually add all the users who will have acces to the app. All the users that are "owner" or "co-owner" can submit and send new data for the list with no problems, but the users included in that group (users only), are facing that patch function error when trying to submit. Can someone help me with that?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @CampoGu,

When working with SharePoint as a datasource for Power Apps, the user will need both access to the app and the list(s) - with the correct SP permissions. The type of list access will depend on what the user should be able to achieve e.g. contribute permissions on the list in case they should be able to view, add, edit & delete items.

Based on the error the user does not have sufficient SP permissions to create an item within the list - they may only have read permissions?

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No
CampoGu 15 on at

Like (1)

Report
Copy link

Link copied!

Hello @LaurensM,
So, I changed the access (that was on view before) to "Can edit itens" and it works now. But my main issue is regarding exaclty this edit permissions. I do not want normal users to remove, add or edit itens from the list, but just view the itens that only that user have created. But I do want them to submit itens to the same List. Is there a way to do this?

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi @CampoGu,

Certainly, this can be done by combining a custom security level to limit the actions (e.g. block delete & edit) with item level permissions on that list (only view and/or edit your own items).

You can create a dedicated security level (on SP site level) by copying the contributor security role and removing the edit & delete permissions. Afterwards you will have to assign this role to the sepcific users / SP group. The following blog post provides a detailed guide on creating this custom security level (block edit & delete).

In order only show(/edit) the rows that the user created, you can leverage SP item level security. This setting can be enabled by going to your list settings:

Under general settings, select 'Advanced settings'. You will be able to adjust the item level permissions:

Reza has a great guide on SharePoint item level permissions.

If this solves your question, would you be so kind as to accept it as a solution. ✔️

If you liked my solution, please give it a thumbs up. 👍

Connect with me: LinkedIn | Blog

Was this reply helpful? Yes No