Data table columns full of blanks when played outside editor, values visible when played inside editor

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a tablet layout canvas app with a screen that contains a data table.

The table reads from an on-prem SQL view.

The items attribute is:

SortByColumns(Filter('[schema].[SQLview]',LocationKey = gvarLocation.LocationKey),"ActualCreatedDate",Descending,"ActualKey",Ascending,"RowOrder",Ascending)

When I play the app from within the editor (hold down Alt), the table presents correctly.

When I play the app from Chrome or Edge, outside the editor, the table shows data in only one of the columns - all the other columns are blank. The rows are there because I see a value for that one column for many rows.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

One thing to check is the 'explicit column selection' setting. If this is enabled, can you try disabling it to see if it makes a difference?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion, but turning explicit column selection off results in no data in the table at all when in play mode. In the editor, the data table still presents the data correctly. Anything else I can try?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not sure which feature setting was actually the culprit but I've got the data table working now by turning off all preview and experimental features except Enhanced SQL Server connector and Enhanced formula bar. So there some setting in there that is causing the data table issues.