PowerApps / Excel Table Issue

[NotBatman]

Hi all,

 

Anyone with PowerApps experience that might have seen this issue before?

 

I've got an Excel spreadsheet setup with some defined tables so I can capture data via some forms, pretty standard stuff. However, and this has happened repeatedly

now, PowerApps keeps 'corrupting' my tables on Excel for want of a better term.

 

I define a table range as say, A2:F2 and leave a column space at the end for the PowerApps ID column which it injects. Then seemingly at random I'll find the table range has shifted in Excel without warning, so the range might now be A2:E2, and the table headers have been overwritten.

 

Here's a screenshot:

 

 

See how the last column, ot5, has been removed from the table and a new column added at the beginning with a generic header, Column1? It's. Driving. Me. Insane. I don't know what I'm doing wrong.