I have an SPO list with several records (Nominations), and each record contains a Person field (Nominees) that allows multiple selections. In the app, I'm showing a single Nomination based on a selection from the previous gallery (Gallery1) and I would like to show the Nominees in a separate gallery, with one entry for each Nominee. I've managed to create a gallery that shows ALL nominees, but I'm having trouble figuring out how to get it to only show the nominees from the selected record. I've tried using Filter and LookUp functions, but I'm not sure where to place them. None of my trial and error has panned out, so I figure it's time to ask for help! Below is the current code that returns a gallery of all Nominees.
With(
{Items: Ungroup(ForAll
('AoE-Nominations',Nominees),"Value"),
DistinctEmail:Distinct(Ungroup(ForAll('AoE-Nominations',Nominees),"Value"),Email)},
Sort(
ForAll(DistinctEmail,First(Filter(Items,Email=Result))),
DisplayName
)
)
Hi @Sworek ,
Have you tried:
Gallery2.Items = Gallery1.Selected.Nominees
?
This should return a table (since the Nominees column allows for multiple selection) that has all the Nominees in it for the selected Nomination in Gallery1.
Hi @BCBuizer ,
I had not tried that! It doesn't seem to work, however. Gallery1 uses PowerBIIntegration as it's data source, so I've had to use lookup to set the item for the Nomination. I assume I would need to do something similar for the items for the Nominees gallery.
Thanks for your suggestion @BCBuizer! I went to basics (I knew it shouldn't be this complicated) and this formula worked:
LookUp('AoE-Nominations',ID = Value(Gallery1.Selected.ID),Nominees)
User | Count |
---|---|
256 | |
111 | |
95 | |
48 | |
40 |