Hello All,
We are having this concerning issue that has seemingly started for no apparent reason. Since 25/06/2026. Some context for the system we have created and how it works:
The System/Stack:
The system is used to account for vehicles stored on our site, and allows users to check vehicles in/out and record certain details of these vehicles like make, model and colour etc. The structure is as follows:
Data Storage - Excel File on OneDrive.
User Interaction - PowerApps App connected to the OneDrive Excel file.
Background processes - PowerAutomate - Archiving and Accounting are done via PowerAutomate at times when our site is closed down.
Dashboard Viewing - PowerBI Dashboard linked to live dataset using OneDrive Excel file.
I understand that Excel is not the most robust data source but this system has worked without issue for three years, and we have not changed anything for months preceding this issue. We have two users on the app who have their own accounts.
Recent Changes Made:
We recently conducted a stock check and
The Issue:
Users edit data via a form on the PowerApp, which when submitted using SubmitForm(Formname), sends this data to the OneDrive file. We have a strict no-editing rule on the file so that the file is never in direct use when the PowerApp is in use. We first noticed an issue when operatives were attempting to check out vehicles, but these vehicles were not appearing on the app as checked in or out. We checked in the base file and these records were completely gone - which is unusual as we have an Archiving flow that removes these checked out vehicles after 2 weeks from their checked out date. We checked the Archive and there were no cars in the Archive file either - it turned out that the Archive had partially failed between 25/07/2026 and I believe it was 03/07/2026. We looked into the flow raw outputs and couldn't see any trace of these vehicle's VIN numbers (used as unique identifiers in the flow), which was odd because PowerAutomate would have contained these VIN numbers to modify those records - we disabled all related flows on 06/07/2026 and the issue continues.
We found there to be around 10-15 cars that had completely disappeared from the main file without a trace - which was completely unheard of before and there was only one Remove() function which was in a dedicated delete row action which hadn't been used. We found these cars in the backup versions of the main file with no trace of being removed.
We then had the issue again a few days later where around 20 cars went missing in the same fashion. We have had to restore these manually in the Excel file, most recently we have had the issue again two days in a row where our operatives have noticed error messages when submitting vehicles and this is when they go missing. The latest occurrence had 32 cars disappear at once. We then manually added these records back in and those exact records were removed again the following day! This is a timeline of the most recent occurrence:
20/07/2026 @ 5:07PM - Starting Point
21/07/2026 @ 10:16 - App in use routine use from around 8:00AM, everything normal
21/07/2026 @ 10:36 - 32 vehicle records are now missing (all checked in on that day) with no trace or error logs recorded in App.OnError.
21/07/2026 @ 16:30 - Missing records manually restored during the day through base file on M365 Online and still appear at this time.
22/07/2026 @ 11:40 - Records still showing, new cars added to the database.
22/07/2026 @ 11:45 - All 32 cars removed again leaving the previously booked in cars where they were.
Other instances have taken cars at complete random with no relation to each other. I have now had instances where the online version histories do not contain certain vehicles, and then later on for no apparent reason these records are then available on the App and database? Is there some kind of sync issue?
I apologise if this seems frantic but it is very concerning for an app that has functioned without issue for around 3 years. What is also more concerning is there are sister apps which run in parallel which function identically and seem to be having similar sync issues - although they are on much smaller scales so the signs are not as obvious.
If anyone has any advice on this issue I would be most grateful.
Kind regards,
Ethan.
