App is inaccessible

[Martina_Hawkins]

Does anyone know what this error may mean?

I got below error first and had to reconnect source of all tables but still wouldn’t sync

Logging in and out does nothing. I contacted support but no reply yet.
Users despearate to get back into app.

[Koichi_Tsuji]

Mis-matching the number of the column, between App and Excel source sheet, as far as the error is indicating why errors comes out.
Did you add columns to spreadsheet without regenerating the tables under Appsheet editor?

[Martina_Hawkins]

No, app has been working fine for months, no changes. Source and definition are the same. I had an issue with access Tokens earlier. I canot access one of my Microsoft data sources ( the one that this app uses) so I changed the sources of the table to the main data source and now have these errors. shouldn’t make any difference what the source is as it is pulling from a spreadsheet in Sharepoint. I have MSOddice- 6 data source but I cannot see the Sharepoint date from it

And no I cannot switch to Google
Have contacted support but not very useful
Need Access tokens refreshed, signing in and out does not do this.

[Koichi_Tsuji]

I never used Excel as data source for AppSheet, so no working suggestion from my end.
It is possible Excel (MS) may change the codes for connecting the Excel file on the cloud, that is possible reason, as far as you are not able to see any file on Sharepoint.

[Steve]

Martina:

No, app has been working fine for months, no changes. Source and definition are the same.

Martina:

so I changed the sources of the table to the main data source

If you changed the sources, the app has changed. The new sources are clearly not the same as the old.

[Martina_Hawkins]

I didn’t change the actual spreadsheet source, it is still the same spreadsheet in the same location in sharePoint. I changed the microsoft Data Source from microsodt354-6 to the main Microsoft data souce

[Steve]

Martina:

I changed the microsoft Data Source from microsodt354-6 to the main Microsoft data souce

I have no idea what that mean. Can you explain?

[Martina_Hawkins]

I am referring to these sources @Steve

[Steve]

In order to troubleshoot this, we need to get on the same page. If you’re working with us here in the community and with Support simultaneously, we’re likely to step on each other and make things worse.