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

(0) Share

Report

Posted on by mithtiwari

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

mithtiwari 28 on at

Like (0)

Report
Copy link

Link copied!

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.

Thanks,
Mithilesh

Was this reply helpful? Yes No