PowerApps_ID columns not showing up in the tables

(1) Share

Report

Posted on by Kelvirino

Rookie's question:

Excel tables are in OneDrive. OneDrive is connected to Power Apps. All (5) Excel tables show up in the Data window. In the Properties window for each dropdown field to which one of these tables is to correspond, the table is selected in Items, and again in the Fields/Edit line (i.e., Add a Field). Everything is Saved. But when in preview, no data shows for any of these fields; and in the Excel tables in OneDrive, no PowerApps_ID column is created, despite the established connection to Power Apps. What am I missing?

Please and thank you.

TSM

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (2)

Report

Hi

Post pictures, not just words, you are asking us to "imagine" what it is.

Happy to help but gotta make it easier to do so

Was this reply helpful? Yes No
timl 36,411 Super User 2025 Season 2 on at

Like (0)

Report

Hi Kelvirino

When you connected your Excel table to your app, did your Excel spreadsheet contain any data? If not, I would add sample data to the spreadsheet before connecting it to Power Apps.

Unlike other data sources like SharePoint/Dataverse where data types are defined, with Excel, Power Apps determines the data type of a column based on the first n rows so populating it with sample data helps it to correctly identify the data type.

The PowerApps_ID column is created when you connect to Excel via the 'OneDrive connector'. If you connected using the 'Excel Online Business' connector, you can choose to PowerApps_ID column when connecting. Therefore, I'd double check the connector that you've used.

Was this reply helpful? Yes No
Kelvirino 16 on at

Like (0)

Report

Thanks, timl .

Yes, all my Excel tables contained data. And I checked - all of my connections were via the OneDrive connector.

And then - I decided to refresh all of these connections via the elipsis beside each table's connection icon in the Data menu - even though there was nothing new about the connections or the content of the tables since establishing said connections on October 7th. But suddenly, I had a PowerApps_ID column for each and every table, and a Preview has all data showing up and dropping down as intended.

All is well. Thanks again.

Kelvirino.

Was this reply helpful? Yes No