
Announcements
Hello All,
I am new to PowerApps and have a project which relies on outputting data to various excel sheets. I have never used patch before.
In OnSelect, for an icon I am attempting to:
The code I am using is pasted in below.
SubmitForm(EditForm1);
Patch(
VendorToWaferID,
Defaults(VendorToWaferID),
{
Batch ID: DataCardValue18.text,
Wafer ID: DataCardValue10.text,
Vendor Box ID: DataCardValue19.text,
Vendor Box Slot: DataCardValue20.int,
Vendor Ingot No: DataCardValue21.int,
Date of batch up: now(),
Operator: DataCardValue2.SelectedText.Value
}
);
Navigate(BrowseScreen1)
The errors I get are quite random so I think my code is at fault. Please could someone take a look at the OnSelect input and tell me if there is anything wrong. I have removed the patch code and the other 2 commands work correctly, so the error is in the patch.
Thank you all in advance.
Hi
Try this
Patch( VendorToWaferID, Defaults(VendorToWaferID),
{ 'Batch ID': DataCardValue18.Text,
'Wafer ID': DataCardValue10.Text,
'Vendor Box ID': DataCardValue19.Text,
'Vendor Box Slot': DataCardValue20.Value,
'Vendor Ingot No': DataCardValue21.Value,
'Date of batch up': Now(),
'Operator': DataCardValue2.SelectedText.Value } )
Or
SubmitForm(EditForm1);
Patch(
VendorToWaferID,
Defaults(VendorToWaferID),
{
'Batch ID': DataCardValue18.Text,
'Wafer ID': DataCardValue10.Text,
'Vendor Box ID': DataCardValue19.Text,
'Vendor Box Slot': Value(DataCardValue20.Text),
'Vendor Ingot No': Value(DataCardValue21.Text),
'Date of batch up': Now(),
Operator: DataCardValue2.SelectedText.Value
}
);
Navigate(BrowseScreen1)
Thanks!
If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.