Im currently trying to save all my values to an extra table. the error only occurs after I try to patch and I dont know whats wrong.
the table has a auto increment primary key (id), a date column with GetDate() as default and Im using the Defaults function in my patch function.
DeviceId: Text(Device_ID_DataCard2.Update);
DeviceType: Text(ComboBox1_3.Selected.Result);
DeviceManufacturer: Text(ComboBox1_7.Selected.Result);
DeviceDescription1: Text(ComboBox1_8.Selected.Result);
DeviceDescription2: Text(ComboBox1_9.Selected.Result);
UserId: Text(OwnerId_DataCard2.Update);
UserFirstName: Text(
First(
Filter(
UserList;
(ComboBox1_10.Selected.DisplayName in DisplayName)
)
).FirstName
);
UserLastName: Text(
First(
Filter(
UserList;
(ComboBox1_10.Selected.DisplayName in DisplayName)
)
).LastName
);
UserEmail: Text(
First(
Filter(
UserList;
(ComboBox1_10.Selected.DisplayName in DisplayName)
)
).Email
);
UserDisplayName: Text(ComboBox1_10.Selected.DisplayName);
LocationId: Text(LocationId_DataCard2.Update);
LocationDescription1: ComboBox1_11.Selected.Description1;
InventoryId: Text(NewBarCode);
InventorySerialNumber: Text(SerialNo_DataCard1.Update);
InventoryPrivate: Text(Private_DataCard2.Update);
InventoryNotice: Text(Notice_DataCard1.Update);
InventoryCreator: Text(Creator_DataCard1.Update);
InventoryOldInventoryNumber: "";
InventoryDateShopped: Text(DateShopped_DataCard1.Update);
InventoryDguvCheck: DguvCheck_DataCard1.Update;
DguvId: Text(DguvId_DataCard1.Update);
DguvPowerSupply: Text(DataCardValue14_6.Text);
DguvConsumption: Text(DataCardValue14_7.Text);
DguvDateNextCheck: Text(DataCardValue7_1.SelectedDate);
DguvDateChecked: Text(DataCardValue7_2.SelectedDate)
I have also tried to save this values as collection (ClearCollect) and tried to patch the collection with the ForAll Function
The Error
