Hi @simms7400 ,
Could you please share a bit more about the Device_Flag field in your SP List? Is it a LookUp field or a Choice type field?
Do you want to update the Device_Flag field of the Submitted record from your form into TRUE value?
Based on the needs that you mentioned, I think there is something with your formula. The Patch formula you provided above could be only used to create a new record in your SP List rather than update existing record.
According to the needs you mentioned, I think the OnSuccess property of the Edit form and Patch function could achieve your needs. I have made a test on my side, please take a try with the following workaround:
Set the OnSelect property of the "Submit" button to following:
SubmitForm(InvestmentEditForm);
Set the OnSuccess property of the InvestmentEditForm to following:
Patch(
rdInvestments,
LookUp(rdInvestments, ID = InvestmentEditForm.LastSubmit.ID),
{
Device_Flag: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:1,
Value:"TRUE"
}
}
);
NewForm(InvestmentEditForm);
Navigate(InvestmentEditScreen, ScreenTransition.None);
UpdateContext({boolPopUpOwnership: false})
Please consider take a try with above solution, then check if the issue is solved.
Note: The OnSuccess property of Edit form would be fired when you submit your Edit form data successfully.
Best regards,
