Showing results for 
Search instead for 
Did you mean: 
New Member

Losing connection from Power App to Excel Table

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.  


Any advice would be appreciated!



Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (64,112)