Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - GCC, GCCH, DoD - Federal App Maker...
Unanswered

Data Table displaying excel information not visible on run

(0) ShareShare
ReportReport
Posted on by 25
Issue:
I built a power application for our company's hardware inventory. In the designer, I have put together a display table element and populated it with our inventory information using an excel online (business) connection. Everything shows up fine in the designer but when I try to use the app in Microsoft Teams or in a browser, the entire data table is missing.
 
Additional information:
All information displayed on the table can still be accessed and manipulated through controls in the app with accurate/up-to-date data, but the data table visualizing the information is absent. All elements of the table have true visibility, and the problem is only apparent when accessing the app outside of the designer. I can still see the table when I run the app from within the designer. All other data tables in the app display normally both in and outside of the designer, all of which are using the same excel online (business) connection to the same excel document, just different tables within it. The problem table is 13 columns by 31 rows, all other tables have less than 31 rows but the same 13 (or less) columns.
 
Any help would be greatly appreciated!
Categories:
  • Suggested answer
    CU29101520-0 Profile Picture
    25 on at
    Data Table displaying excel information not visible on run
    Upon further testing, it appears that the issue stemmed from a handful of empty date fields in the excel table. When provided with a default date of 1/1/2001, our inventory table is visible and functional yet again. This fix had to be applied to every empty date field, as even one cell without a date value caused the table to disappear again.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics