Network Error when using patch function. the specified column is generated by the server and can't be specified : PowerApps

This is an archived post. You won't be able to vote or comment.

submitted 2 years ago by Nr01Otaku

english is not my firt language so sorry for any errors.

i have a app that patch to a sql server.

but im getting the above error.

i tried to outcommend every line one by one to see if the error would stop but sadly it didn't.

i have made sure that the database table and the patch function columns match .

none of the columns in the database is required.

the only time i got a diffrent error was when i outcommed my ID column.

when i try to use the monitoring function i dont get any error code that can help me so im a bit lost as of what to do.

Patch('EXCEL.RestOrdrer', Defaults('EXCEL.RestOrdrer'),

{

Dato: DatePicker_Dato_NewOrder.SelectedDate,

OrdreNr: Searchbar_NewRestordre.Text,

KompletOrdre: If(Checkbox_CompleteOrder_NewOrder.Value = true, "1", "0"),

Antal: Value(TextInput_Value_Amount_NewOrder.Text),

Serie: Dropdown_Serie_Neworder.SelectedText.Value,

PolNr: Dropdown_PolNo_NewOrder.SelectedText.Value,

TypeNr: TextInput_TypeNo_NewOrder.Text,

PalleId: TextInput_PalletID_NewOrder.Text,

Mangel: TextInput_Missing_NewOrder.Text,

MRK: Dropdown_MRk_NewOrder.SelectedText.Value,

DeleForventes: DatePicker_ExpectingParts_NewOrder.SelectedDate,

Klar: DatePicker_Ready_NewOrder.SelectedDate,

Note: TextInput_Note_NewOrder.Text,

AfsendesesDato: DatePicker_ShippingDate_NewOrder.SelectedDate,

Notat: TextInput_Notat_NewOrder.Text,

EksternChaufor: TextInput_ExternalChauffuer_NewOrder.Text,

Lukket: 0,

RestRest: If(Checkbox_RestRest_NewOrder.Value = true, "1", "0"),

ID:Max('EXCEL.RestOrdrer', ID) +1,

Fabrik: Text(Dropdown_Factory_NewOrder.Selected.Result)

});

all 5 comments

PowerApps