web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data Table displaying ...
Power Apps
Suggested Answer

Data Table displaying excel information not visible on run

(0) ShareShare
ReportReport
Posted on by 27
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!
I have the same question (0)
  • Suggested answer
    CU29101520-0 Profile Picture
    27 on at
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard