How to filter distinct records in a gallery in a gallery

(1) Share

Report

Posted on by GreenFrog

Hey all,

I have three dataverse tables, Location and Issues, Country

Location

countryID (lookup) townID (lookup) titleID (lookup)

1 45 20

1 46 21

1 47 22

2 48 23

2 49 24

3 50 25

3 51 26

CountryDetails

countryID description

1 Text description 1

2 Text description 2

3 Text description 3

Town details

townID issues

45 Text for issue 1

46. Text for issue 2

47. Text for issue 2

48. Text for issue 3

49 Text for issue 4

I am trying to display a gallery in a gallery by using the Location table as the data source. I am trying to show the distinct description in the first gallery and in the second gallery, when a user selects a description, the second gallery shows this issues by filtering the countryID. The gallery show look like

description Text for issue

Text for issue

description Text for issue

Text for issue

description Text for issue

my code for the items in the second gallery is

Filter(

Location

townID = gal_one.Selected.Value

)

Any suggestions on where I am going wrong would be really helpful.

thank you for helping.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

AmínAA 1,228 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Greetings!

I don't seem to have fully grasped what you are trying to achieve there . . . Can you show some images of what you're working in? Also, just in case, I have thought on something that may work for the code you displayed up there. . .
Filter( Location townID = gal_one.Selected.Value ).'YOUR COLUMN NAME'

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @GreenFrog ,
To achieve the desired layout for your galleries, where you have a list of descriptions in the first gallery and the corresponding issues in the second gallery based on the selected description, follow these steps:
First Gallery (gal_one) Setup:
Set the Items property of the first gallery (gal_one) to show distinct descriptions from the CountryDetails table.

Distinct(CountryDetails, description)

Second Gallery (gal_two) Setup:
Set the Items property of the second gallery (gal_two) to filter issues based on the selected description from the first gallery. You will need to use the Location, CountryDetails, and TownDetails tables to achieve this.
Here’s how you can structure the formula for the Items property of the second gallery:

Filter( AddColumns( Location, "countryDescription", Lookup(CountryDetails, countryID = Location.countryID).description, "townIssues", Lookup(TownDetails, townID = Location.townID).issues ), countryDescription = gal_one.Selected.Result ).townIssues

Was this reply helpful? Yes No