cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

App not communicating with Excel table

I copied and pasted two columns into my database table and my app will no longer read data from that table. My database is an excel sheet stored in dropbox and has not had problems until now. 

 

I've tried deleting formatting from the table, disconnecting the table and reconnecting, deleting the new columns. I've changed the datasource for the gallery to an adjacent table in the same excel sheet and it communicates swimmingly. 

 

Any ideas what I did to my table that PowerApps will recognize it, but not read any of its data?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: App not communicating with Excel table

Hi @Jdscott

 

For these types of error, I would suggest that you copy all your data into a new Excel file, and to replace your existing spreadsheet with the new file.

 

I also recommend placing each table in separate worksheet. PowerApps needs to create an auto-generated __PowerAppsID__ column for each table. Placing each table in a separate worksheet prevents any problems that might occur if there isn't space between the adjoining tables in a worksheet.

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: App not communicating with Excel table

Hi @Jdscott

 

For these types of error, I would suggest that you copy all your data into a new Excel file, and to replace your existing spreadsheet with the new file.

 

I also recommend placing each table in separate worksheet. PowerApps needs to create an auto-generated __PowerAppsID__ column for each table. Placing each table in a separate worksheet prevents any problems that might occur if there isn't space between the adjoining tables in a worksheet.

 

View solution in original post

Highlighted
Helper II
Helper II

Re: App not communicating with Excel table

After redoing many of the data and item fields in my app, I finally had the app working again. Then PowerApps stopped communicating with my new table.

 

What gives? 

 

Help me out, Microsoft. What am I doing to break your program?

Highlighted
Regular Visitor

Re: App not communicating with Excel table

I am having the same problems. Experimenting with PowerApps and the datasource being an Excel file in OneDrive for Business. Cannot get it to work in a stable fashion. Data disappears often, ie. the App is not always updating the Excel file when adding a new record. The format of the date column regularly gets messed up. 

However: using SQL Server on a local machine as the data source works well.

J.

Highlighted
Helper I
Helper I

Re: App not communicating with Excel table

Despite having my tables on separate spreadsheets I am experiencing problems working with OneDrive for Business Excel. Redoing all my tables in a new workbook is not a solution and should not be accepted as such.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (5,122)