cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Filtering Gallery

Hello

I have a SPtable containing

Idnr , Region , City , Village , Team


I have 5 Regions with max 10 Citys , max 15 Villages  and tehy can have  max 5 Teams

I want to set a filter in the gallery so it shows

Regions with the Citys and Villages without duplicates 

I have been trying with GroupBY and Filter  , i can only see one column 

GroupBy(Filter(tbl_teams;region=ddregion.SelectedText.Value);"City";"region")
Any idea how to think here

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Try:

Distinct(tbl_teams,region & "-" & city& "-" & village)
 
If you dont like the result below, please show a sample of the Output you want like want you showed in your reply
duplicate2.JPG
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

View solution in original post

5 REPLIES 5
eka24
Super User
Super User

Try:

Distinct(tbl_teams,Village )

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Nice workaround  , but the names of the teams can be the same 

Show a sample of your table and if you can explain further

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Here is the table 

id  region  city village team  

1WAvestaFors8 - 10
2WAvestaFors11-13
3WAvestaAvesta14-15
4WAvestaAvesta8 - 10
5WFalunBojsenburg11-13
6WFalunBojsenburg14-15
7VVästeråsBäckby8 - 10
8VVästeråsEriksberg11-13
9VVästeråsEriksberg14-15
10XGävleHille8 - 10
11XGävleHille11-13
12XGävleBomhus14-15
eka24
Super User
Super User

Try:

Distinct(tbl_teams,region & "-" & city& "-" & village)
 
If you dont like the result below, please show a sample of the Output you want like want you showed in your reply
duplicate2.JPG
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,480)