Unanswered

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

(1) Share

Report

Posted on by amarnay Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @amarnay ,

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

Was this reply helpful? Yes No
amarnay Microsoft Employee on at

Like (0)

Report

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

Permission.png

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@amarnay ,

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Matts-Apps 16 on at

Like (2)

Report

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

Was this reply helpful? Yes No
glnnhoffman 9 on at

Like (1)

Report

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

Was this reply helpful? Yes No
davenlh 15 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Matts-Apps 16 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
glnnhoffman 9 on at

Like (0)

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

Was this reply helpful? Yes No
Smontego1 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No