Filtering Gallery

[dalacarelia_196]

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

[eka24]

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.

[dalacarelia_196]

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

[eka24]

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.

[dalacarelia_196]

Here is the table 

id  region  city village team  

1	W	Avesta	Fors	8 - 10
2	W	Avesta	Fors	11-13
3	W	Avesta	Avesta	14-15
4	W	Avesta	Avesta	8 - 10
5	W	Falun	Bojsenburg	11-13
6	W	Falun	Bojsenburg	14-15
7	V	Västerås	Bäckby	8 - 10
8	V	Västerås	Eriksberg	11-13
9	V	Västerås	Eriksberg	14-15
10	X	Gävle	Hille	8 - 10
11	X	Gävle	Hille	11-13
12	X	Gävle	Bomhus	14-15

[eka24 · Accepted solution]

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

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

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.