web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Not able to see values...

Power Apps

Answered

Not able to see values in all column.

(0) Share

Report

Report

Posted on by anzocontrols

31

Dear All,

I am facing a weird situation wherein I am not able to see the values of all my columns using this expression:

ClearCollect(LocalDatasetItem, Filter(Inventory, MaterialCodeId = Dropdown9.Selected.MaterialCodeId)).

I am able to see value in few columns but not in all. What could be the reason ? My database has values in all the columns.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @anzocontrols,

I expect this to be occurring due to the Explicit Column Selection setting. In short, this setting will cause your queries to only retrieve rows that are actually needed / used in your app to improve performance - if it is supported by the datasource.

A way to enforce the retrieval of certain column values would the be via the ShowColumns function:

Clearcollect( colData, ShowColumns( //Note: datasource would be your Filter statement Datasource, "Column1", "Column2" ) )

To always load all columns without using the ShowColumns function, you would need to turn this setting off. Please note that it is best practise performance-wise to keep Explicit Column Selection turned on.

Should you want to gain more insight into this setting, be sure to give the following blog post by @timl a read.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Yep - @LaurensM is correct here (and thanks for the link)! Explicit Column Selection will be the cause of this behaviour.

Was this reply helpful? Yes No
anzocontrols 31 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks alot for the help. It solved my issue.

Was this reply helpful? Yes No

Join the conversation