I'm doing something to break my connection to my Excel table. It works for a while, but I get this error (on the computer):
and this on my phone:
"Staff" is the table I'm using in the Power App, but I don't know what 'Table Style 1' is -- I didn't change table styles to my knowledge (just used the default one in Excel). I've tried re-creating Excel file (from pasting "as values") several times and have tried adding things a bit at a time and re-testing (things like data validation tables, format for the date column, adding in extra data I copied over from another sheet, etc.). Somewhere along the way I break the connection, but I haven't been able to isolate what I'm doing wrong. The last time it all seemed fine when I pasted in 3 rows of new data, but then broke when I pasted in a few more.