Power Platform Community Forum Thread Details

Good day,

I have 2 galleries with different datasources and would like to filter one of the list to display all matching records. I can manage to show at least one matching record each time using:
Gallery1

Filter(
 datasource1,
 'Name' = "John"
 'RowId' = 555555555
)

Gallery2

Filter(
 datasource2,
 Id = Gallery2.Selected.Id
)

Additional information: Datasources are Virtual Tables in Dataverse and the connection between these 2 datasources are Id and in datasource2 I have a lookup column into datasource 1.

The Goal with the project: Select items with checkbox true on Gallery2, where visible items are matching all items on Gallery1, and collect them into collection 'colSelectedItems'. Then on another screen edit selected items using ForAll(Patch()). I got the ForAll(Patch()) working.

Here is the picture that showcases how I am doing this, and what I would like to do is display all matching items on gallery1 to show on gallery 2 for selection.

I know why I am getting only 1 item on gallery 2 but I am not able to show all matching items between gallery1 and 2.

I have tried using lookup, tried using collections and I have hit a wall when it comes to figuring this out. Is there anyone who has dealt with this particular issue and has good advice to resolve it?

Thank you in advance

Categories:

Building Power Apps