how to fix network error when using patch function: you don't have permission to create this row

(0) Share

Report

Posted on by ThomasEngels

APP is done and we are running a BETA test version.

Users have an issue with patching a new ITEM to the SP list.

Users have contribute (edit ITEMS)

list advance setting.png

permission and List advance settings are also ok.

Why they get an error ?

Best regards Thomas

Categories:

Building Power Apps

All responses (20)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ThomasEngels ,

Most probably, what you are trying to patch is not in the expected format (like string into a choice or lookup column) or you are using lookup columns to lists where the users don’t have read/write access.
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

That is the ON SELECT of the button:

Patch('Pre Material Order',
ForAll(Gallery5.AllItems,
{Title: Subtitle6.Text,
OrderedQTY:Value(Label7.Text),
EID: Value(Label24.Text),
OrderDATE: Now(),
OrderedBY: varuser.Email,
MID: Title7.Text,
'STORAGE AREA': Label26.Text,
PICTURE: DataCardValue7_3.Image,
UNIT: Label16.Text,
SERVICEnumber: TextInput4.Text,
'TITLE DE': Label25.Text

}
)
)
;Office365Outlook.SendEmail(Concat(colPUonDUTY,Title),"AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & varuser.FullName,
"AFTERMARKET_WAREHOUSE_TOOL_new_order_received from"&" " & varuser.FullName &" "& "at" &" "& Text( Now(), "mm/dd/yyyy hh:mm:ss" )) And Notify("order has been send",NotificationType.Success)
;
UpdateContext({resettext: !resettext});
UpdateContext({resettext: !resettext});
Clear(colOrderItems)
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban

That is the ON SELECT of the button:

Patch('Pre Material Order',
ForAll(Gallery5.AllItems,
{Title: Subtitle6.Text,
OrderedQTY:Value(Label7.Text),
EID: Value(Label24.Text),
OrderDATE: Now(),
OrderedBY: varuser.Email,
MID: Title7.Text,
'STORAGE AREA': Label26.Text,
PICTURE: DataCardValue7_3.Image,
UNIT: Label16.Text,
SERVICEnumber: TextInput4.Text,
'TITLE DE': Label25.Text

}
)
)
;Office365Outlook.SendEmail(Concat(colPUonDUTY,Title),"AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & varuser.FullName,
"AFTERMARKET_WAREHOUSE_TOOL_new_order_received from"&" " & varuser.FullName &" "& "at" &" "& Text( Now(), "mm/dd/yyyy hh:mm:ss" )) And Notify("order has been send",NotificationType.Success)
;
UpdateContext({resettext: !resettext});
UpdateContext({resettext: !resettext});
Clear(colOrderItems)
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
If you are trying to patch existing items, you need to refer to an ID column for each patch when you batch-patch like this.

If you are trying to patch new items, then you need to use the Defaults() function like this:

Patch( 'Pre Material Order', Deafults('Pre Material Order'), ForAll(Gallery5.AllItems, { Title: Subtitle6.Text, OrderedQTY:Value(Label7.Text), EID: Value(Label24.Text), OrderDATE: Now(), OrderedBY: varuser.Email, MID: Title7.Text, 'STORAGE AREA': Label26.Text, PICTURE: DataCardValue7_3.Image, UNIT: Label16.Text, SERVICEnumber: TextInput4.Text, 'TITLE DE': Label25.Text } ) ); Office365Outlook.SendEmail( Concat(colPUonDUTY,Title), "AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & varuser.FullName, "AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & " " & varuser.FullName & " at "& Text( Now(), "mm/dd/yyyy hh:mm:ss" )); Notify("order has been send", NotificationType.Success); UpdateContext({resettext: !resettext}); UpdateContext({resettext: !resettext}); Clear(colOrderItems)
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

I have changed a little bit , because patch / defaults and for all didnt work.

ForAll(Gallery5.AllItems,Patch('Pre Material Order',
Defaults('Pre Material Order'),
{Title: Subtitle6.Text,
OrderedQTY:Value(Label7.Text),
EID: Value(Label24.Text),
OrderDATE: Now(),
OrderedBY: varuser.Email,
MID: Title7.Text,
'STORAGE AREA': Label26.Text,
PICTURE:DataCardValue7_3.Image,
UNIT: Label16.Text,
SERVICEnumber: TextInput4.Text,
'TITLE DE': Label25.Text
})
)
;
Office365Outlook.SendEmail( Concat(colPUonDUTY,Title), "AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & varuser.FullName,
"AFTERMARKET_WAREHOUSE_TOOL_new_order_received from" & " " & varuser.FullName & " at "& Text( Now(), "mm/dd/yyyy hh:mm:ss" ));
Notify("order has been send", NotificationType.Success);
UpdateContext({resettext: !resettext});
UpdateContext({resettext: !resettext});
Clear(colOrderItems)

But users still get the network error.
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone a suggestion what I could try ???
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz do you have an idea , which could cause my issue ?
WarrenBelz 156,774 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@ThomasEngels ,

As @gabibalaban posted at the start, one of your control outputs or values probably does not match the destination field type. There is nothing wrong with the fundamental structure except for performance reasons, you need the ForAll inside the Patch, not the reverse (as per posted by @iAm_ManCat )
BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @ThomasEngels ,

In addition to what was mentioned before, I can recommend using Monitor to try and gather additional information on what is causing this issue. More information on how to use Monitor can be found here: https://learn.microsoft.com/en-us/power-apps/maker/monitor-canvasapps
ThomasEngels 46 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz when I use the patch it works. only users have issues and network failure.
I tried the for all inside the patch as mentioned by @iAm_ManCat , but it didnt work. so i played arround and put the forall before the patch. it works for me but still not for the user.