Filter second gallery based on multiple selections from first gallery

(0) Share

Report

Posted on by karimabdelrazek

294

Hi all!

What is the formula to filter a second gallery based on multiple selections in a first gallery? My first gallery (Gallery A) contains high level activities with checkboxes, and the second gallery (Gallery B) contains their details.

For UX purposes, I've put each gallery on a different screen and would like the user to select all the top level activities from Gallery A, and when moved to the next screen, would have the details filtered for them in Gallery B. Can this be done?

I'm using CDS and a canvas app.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @karimabdelrazek ,

Could you please share a bit more about the data structure of your data source?

How do you bind the Gallery A and Gallery B? Through a Primary Key, e.g. "ActivityId"?

Further, does the Gallery A and Gallery B connect to same data source?

I assume that you bind the Gallery A and Gallery B through a Primary Key column -- ActivityId. Please consider set the Items property of the second Gallery to following:

Filter( Activities, ActivityId in Filter( // filter these items whose checkbox is checked GalleryA.AllItems, Checkbox1.Value = true ).ActivityId )

Note: The ActivityId represents the Primary Key column in your CDS Entity, on your side, you should replace it with 'Unique Identifier' Type column.

Regards,

Was this reply helpful? Yes No
karimabdelrazek 294 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft ,
Thanks for the reply. I bind the two galleries though an "ActivityID" like you mentioned, but the data are in two separate entities. I will try your solution below.

Was this reply helpful? Yes No