I have created a form using various controls such as text input, date picker & togs as this provided more flexibility compared to the traditional forms. I have created a patch command within the OnSelect for the Save button. All the new records which are entered save without any issues, However when i try to amend a existing record. I get the following error message and the form resets and then the amended data is not saved
Patch command is as follows
Patch(
Accounts,
If(IsBlank(varAccount), Defaults(Accounts), varAccount),
{
Title:varUserID,
Domain:
{
Value: ddDomain.SelectedText.Value,
Id: LookUp(Domain, Title = ddDomain.SelectedText.Value).ID
},
'Account Name': txtAccountName.Text,
'Request Number': txtReqNo.Text,
'Last Reviewed':LastReviewed_Date.SelectedDate,
Approver: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & cbApprover.Selected.Mail,
DisplayName: cbApprover.Selected.DisplayName,
Email: cbApprover.Selected.Mail,
Department: "",
JobTitle: "",
Picture: "" // Optional: Include additional user properties as needed
},
'Account Required': AccReq_Tog.Value
}
);
Reset(ddDomain); Reset(txtAccountName); Reset(txtReqNo); Reset(LastReviewed_Date); Reset(cbApprover); Reset(AccReq_Tog)
