I have a Power App that is connected to several SQL Databases for Lookups but also saves in a separate Database/table.
For some reason it appears when the end users edit a record, they can save it and it then disappears/deletes from the database. The only way I have noticed that is that the ID skips. For example Record ID 364,365,366 then it goes to 368 making me assume we are losing rows.
I use the current formulas:
Edit Icon on Select: EditForm(EditForm);Navigate(EditDeskJournal,ScreenTransition.None)
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 Itemsproperty of the ComboBox to following:
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.
Community Support Team _ Kris Dai If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-xida-msftThank you for getting back to me. I checked on the OnSuccess, I have no remove formula there. I added the EditForm.Updates but I am still losing data. I am missing 4 out of 125 entries which is better than before. Could there be another reason why SQL may "skip" an ID? Could there be an issue with multiple people submitting an entry at the same time? Thank you.