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

[amarnay]

I have a PowerApp with SharePoint list as the data source. All users are assigned "member" role @ SharePoint. While submitting the data, some users are facing the error "network error when using patch function. you don't have permission to create this row" whereas some users aren't. How do I resolve this?

[WarrenBelz]

Hi @amarnay ,

I assume "Members" have Contribute permissions (at least) and the list is not restricted to writing only to records they have created ?

[amarnay]

Yes, see the screenshot. They have the highlighted permissions.

[WarrenBelz]

@amarnay ,

Second question I asked - are the Item-level permissions (in Advanced Settings) set correctly ?

[Matts-Apps]

@amarnay I'm facing this same issue, did you find a solution or workaround? 

All of my users have the correct permissions in the Sharepoint list. When I test the app myself I can add a record but when the users are making a form submission through the PowerApp embedded in Teams, they get the same issue. 

I've checked other threads for a solution with no success. 

Solved: Network error when using Patch function: You don't... - Power Platform Community (microsoft....

[glnnhoffman]

@amarnay Were you able to find a solution, by chance? 

I'm dealing with an identical issue, with no pattern between those who do/do not receive the network error. I'm wondering if this is a bug in the current patch function build?

[davenlh]

same exact issue with my App.  No real reason I can see and I'm leery of changing too much and making something else worse.

[Matts-Apps]

I encountered this problem a while ago but here are some of the things I changed that might have contributed to a non-error: 

I had to re-create my SharePoint list columns so that I could use the standard 'form' card elements. If this doesn't work for use case I recommend re-creating the SharePoint site. 

Make sure that you're not using a dropdown or any lookups that are referring to a list made through MS Lists as these are often limited to the creators "my lists" section, even if the list is shared with people. Since then I have had to migrate the content of my 'my lists' list using PowerShell to a SharePoint site. This might be the cause the error when the users are trying to Patch content sourced from that list.

[glnnhoffman]

@davenlh In case it helps, I ended up using a power automate flow as a workaround to avoid the random patch function error. Because the flow is executed on my account, it prevents the error that seemed to be created by the SP list data source.

I used the PowerApps trigger for the flow, created a list item, and then added code to the submit button's OnSelect parameter to run the flow (called flow_requests). I've added the code below, along with a screenshot of my flow. All the variables are specific to my app, the only detail to note is that the number of parameters in the flow must match the number of variables populated in your OnSelect code, and be in the same order. I also linked a helpful video.

https://youtu.be/gwmufQ4Gabs 

Code added to OnSelect (In Power App)

flow_requests.Run(Concatenate(User().Email, Text(Today(), "[$-en-US]yyyy-mm-dd")), User().Email, If(IsBlank(Keyword_Entry.Text), "a", Keyword_Entry.Text), Concat(Topic_Entry.SelectedItems, Interest, ", "), Text(Today(), "[$-en-US]yyyy-mm-dd"), Concat(Source_Entry.SelectedItems, Source, ", "), Start_Date.SelectedDate, End_Date.SelectedDate, "Yes");

MS Flow design

[Smontego1]

I am receiving the same error with a Dataverse Table as my datasource.  Does anyone have the solution for this?