web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SQL Datasource, column...

Power Apps

Suggested Answer

SQL Datasource, column data is not showing when "Disable explicit column selection" is off

(1) Share

Report

Report

Posted on by EL-11090208-0

2

I have an issue with an existing app when "Disable explicit column selection" is off

I'm using a gallery that is based off a view in SQL.

And upon clicking a button in the gallery, it runs the function: ClearCollect(SelectedActionLog,ThisItem);

However, the collection have columns where data is empty when "Disable explicit column selection" is off.

I see that this ""Disable explicit column selection" setting is retired. What does this mean for my app? and what is the work around?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

What permissions do they users have, as they go through the gateway?

You may need to run those queries as either a) each user has the proper permissions or b) as a service account, where the users STILL need a license, but that you can simply have a Service Account do the queries so you only need to give them the required privs, which they do not have since that is off.

That's what I would do

Was this reply helpful? Yes No
Suggested answer

timl 37,248 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Explicit column selection is a performance feature .

With explicit column selection enabled, Power Apps will retrieve only the data that corresponds to columns that are actually shown in your gallery.

This is the reason why your call to ClearCollect, includes empty columns.

To resolve this, you can look up the record rather than reference ThisItem

ClearCollect(SelectedActionLog, LookUp(YourSQLView, PrimaryKeyCol=ThisItem.YourPrimaryKeyCol) );

Alternatively, you can modify the Items property of your gallery and replace the reference to your SQL view to with a call to ShowColumns that explicitly specifies the columns that you want to retrieve.

ShowColumns(YourSQLView, Column1, Column2, Column3, etc)

Was this reply helpful? Yes No

Join the conversation