Unable to sync 2 pending rows — old app version rejects Enum value

Hello AppSheet Community,

I need help recovering two unsynced records from our company Android phone without losing any data.

On October 10, 2026, an employee created two records in the “Registros” table. Both remain pending and fail to sync.

The Audit History shows the following error:

“Value ‘Observação do expediente’ in field ‘Tipo de registro’ cannot be converted to type ‘Enum’.”

The failed operations still reference appTemplateVersion: 1.000117.

We checked version 1.000117 and confirmed that the Enum column only allowed three values. “Observação do expediente” was not included, and “Allow other values” was disabled.

We subsequently added the missing value, enabled “Allow other values”, and even temporarily changed the column type from Enum to Text in the current app version. However, the two pending operations still fail with the same error.

The records are not visible in the app’s normal list, and the sync error screen does not offer a way to view or copy their contents.

My question: Is there a safe way to recover or synchronize these two pending records created under an older app definition, without clearing local data, discarding changes, reinstalling the app, or losing the original records?

Thank you for your help.

Hi,
This is what Recovery mode is for. Fixing the current version won’t help because the queued rows are tied to the old app version.

First, make a copy on the phone so nothing can be lost: on the Android device, open the sync error and use “Show Changes”. It emails a copy of the queued changes to you or the owner and saves a copy to the recovery folder. Do this before anything else.

Then:

  1. In the editor go to Manage > Deploy and select “Switch to recovery mode”.
  2. On the phone, retry the sync. Instead of being applied, the 2 queued rows are saved as JSON files in a “_recoveryData” folder in the app’s root folder in the owner’s Drive.
  3. Go back to Manage > Deploy and select “Return to normal mode”.
  4. Copy the values from the JSON into your table, then clear the stuck changes on the phone.

One warning: if this app’s data source is AppSheet Database rather than a Google Sheet, check the “Show Changes” copy arrived before step 2. There’s a forum report of recovery mode not creating the folder with AppSheet Database: Recovery mode does not work with AppSheet Database: no `_recoveryData` folder is created and pending changes are silently lost (sync reports "success" on desktop browser)

Details: Errors and warnings during Sync - AppSheet Help