Hi @Melinda ,
Have you put some Remove formula within the OnSuccess property of the Edit form in your app?
Based on the formula you provided, I could not find any formula which is used to remove/delete record from your table. Please check if you have added a Remove formula within the OnSuccess property of the Edit form, when your submit your form data successfully, the OnSuccess property of the Edit form would be fired.
In addition, please consider take a try with the following workaround:
Set the Items property of the ComboBox to following:
SortByColumns(Filter(Lookup_Database',Filter1=Value),Column,Ascending)
Set the DefaultSelectedItems property of the ComboBox to following:
If(
EditForm.Mode = FormMode.Edit,
Filter(Lookup_Database, Column = Gallery1.Selected.Column).Column
)
or
{
Column: Gallery1.Selected.Column
}
Set the OnSelect property of the "Submit" button to following:
If(
EditForm.Mode = FormMode.Edit,
Patch(
Main_Database,
Gallery1.Selected,
EditForm.Updates
),
Patch(
Main_Database,
Defaults(Main_Database),
EditForm.Updates
)
);
ResetForm(EditForm);
Back()
In addition, please also check if you set up a ms flow to delete the record from your table when a record is modified.
If the issue still exists, please consider re-generate a new app based on your table data source, then configure the combobox data cards in your Edit form, then try the app again, check if the issue is solved.
Best regards,
