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 / Collection created on ...
Power Apps
Answered

Collection created on Dataverse Table does not show all values from the table row in the collection

(0) ShareShare
ReportReport
Posted on by 28

Hi All,

 

I need help, please.

 

I have 2 tables created in Dataverse.

 

One is a Dimension Table and the second one is a Fact Table.

 

I have 2 galleries on a canvas form. One gallery is connected to the Dimension Table. And the second gallery has a filter to show details based on the item selected in the first gallery.

 

The relationship between the two table is one:many.

 

In the second gallery, I also have created a check box. When a check box is selected, the item is collected in a collection.

 

The problem is that the collection does not show all values of the item type in the table. The collection shows values in few columns.

 

Any advise what am I missing here?

 

Please help.

 

Thanks,

Mithilesh

I have the same question (0)
  • ivan_apps Profile Picture
    2,189 Moderator on at

    In the second gallery, what are you collecting when you check the box? The record or are you collecting a custom object of data that you displayed? I would create a third gallery to troubleshoot and load your collection and display several fields from it. Have those same fields display on your Fact table gallery and see if they truly are missing or if you collected the data incorrectly.

     

  • Verified answer
    mithtiwari Profile Picture
    28 on at

    Hi @ivan_apps ,

     

    Thank you for responding. I found a way to bring all columns with their values in collection.

     

    I disabled the "Explicit Column Selection" in the Upcoming Features under Settings.

     

    mithtiwari_0-1704996995412.png

     

    Thanks,

    Mithilesh

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard