Filter Gallery on second column value

(0) Share

Report

Posted on by QuinceKa

Hi all!

I actually try to achieve something I never did before and constantly run into failures.

I have a simple SharePoint List with two Columns:

- Team

- Player

Bildschirmfoto 2022-04-18 um 23.33.50.png

I now push this data into a Gallery (Distinct).

Bildschirmfoto 2022-04-18 um 23.38.00.png

What I want to do now is to select MULTIPLE items from the gallery (Teams) and only show those Players in the second Gallery, that play in ALL selected Teams but can´t find out how to achieve that.

Maybe anybody did that before.

Cheers, Quince

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I believe the Items formula for the Player gallery would look like this:

Filter(TestListFilterApp, Team = TeamGallery.Selected.Value)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@QuinceKa

Instead of a gallery use a Listbox control with the SelectMultiple property true for the teams. Set the Items property of the listbox to Sort(Distinct(splist, Team),Result)

In the player gallery set the Items to Filter(splist, Player in Listbox1.SelectedItems) In the example in the screenshot, I have a list of sales figures by region and country, analogous to your Teams and players. As you can see, the gallery on the right has a combination of countries in both selected regiions.

Was this reply helpful? Yes No
QuinceKa 16 on at

Like (0)

Report
Copy link

Link copied!

HI @Jeff_Thorpe ,

thanks for your answer.
I tested your answer and this works for one selected Item. My question is how to do this with multiple selected Items from the Gallery.
I suppose I have to set up a Collection on the onselect property of the teams gallery but how can I filter for players who are playing in all selected teams?

BR, Quince

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@QuinceKa

And that is more complicated than my suggestion.

Was this reply helpful? Yes No
QuinceKa 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp ,

yes, this is the problem. I don´t find a working filter syntax to get to a solution.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @QuinceKa,

Do you want to filter the Player based on multi Gallery selected?

I have a test on my side, please take a try as below.

1). Set the OnSelect property of the Gallery as below:

Collect(colTeams,Gallery1.Selected)

2). Set the player Gallery Items property as below:

Ungroup(ForAll(colTeams.Result,Filter(TestListFilterApp,Result in Team)),"Value")

Was this reply helpful? Yes No
QuinceKa 16 on at

Like (0)

Report
Copy link

Link copied!
Hi Qi,

thanks for your answer.

F.expl:

Team | Player
1. Team | Player 1; Player 2
2. Team | Player 1; Player 3

The second expression
Ungroup(ForAll(colTeams.Result,Filter(TestListFilterApp,Result in Team)),"Value")
returns all players if I select 1. Team and 2. Team ->Player 1, Player 2,Player 1,Player 3

What I want is the Player who plays in both teams: Player 1

Cheers, Quince

Was this reply helpful? Yes No