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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Datatable columns have...
Power Apps
Unanswered

Datatable columns have a question mark and are missing text property - will not load properly

(0) ShareShare
ReportReport
Posted on by 4

Hi,

Issue: when trying to use datatables (excel file), I can add the datatable without any issues. When I try to select a column from the excel file, the data view on power apps goes into indefinite loading and never refreshes. the view remains stuck on the loading spinner. I can actually add that column by saving the project, exit and reopen it. I have to do this for every column, because it always gets stuck at the loading spinner. After adding all of my columns I noticed, that the columns on the tree view panel do not have the "column" symbol, but just a question mark (See picture 1). Also, the text property is missing (see picture 2 for available properties). I guess that is a consequence of the loading spinner issue.

 

Picture 1: 

supperz_0-1661525155585.png

 

Picture 2:

supperz_2-1661525207672.png

 

Here is what I already tried: used 3 different browsers (chrome, firefox and edge), used normal and incognito mode on all of them. Switched computer (both on Windows 10). Switched excel files. persistent issue on all of them.

 

I do not have a solution for that. Anyone else had that issue before? The Datatable seems fine and displays the correct values, but I need to edit the text property.

 

 

Thank you!

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @supperz 

    Once an excel table is imported to PowerApps changing is schema in Excel frequently becomes corrupted. For many reasons excel is a terrible datasource. https://m.youtube.com/watch?v=RtmZM3tm2Zs consider using SharePoint instead.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 914

#2
11manish Profile Picture

11manish 617

#3
Valantis Profile Picture

Valantis 598

Last 30 days Overall leaderboard