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

[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)

 

permission and List advance settings are also ok.

Why they get an error ?

Best regards Thomas 

[gabibalaban]

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

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]

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

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]

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]

Anyone a suggestion what I could try ???

[ThomasEngels]

@WarrenBelz do you have an idea , which could cause my issue ?

[WarrenBelz]

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

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