web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps "Cascading" Galaries w...

Power Apps

Answered

"Cascading" Galaries with distinct values

(0) Share

Report

Report

Posted on by TJCappy

90

Hello,

I am very frustrated because I cannot do what I would like to no matter what I try.

Here is my scenario

I have a sharepoint list (A) that i use to retrive information from to use when I create a new item on list (B)

list ha has the following columns

HireType, Division, Region, RegionCode, Team, TeamCode, Title, TitleCode

Of the above columns the only two with unique vallues are, Title & Title Code.

All others have duplicate values.

I would like to create three galleries that would work in the following way

gallery1 lists all unique values from the region column

gallery2 will then show only those teams that belong to the region picked in Gallery1

gallery3 displays the information required for the chosen team (it gets tat info from a different list.

I have mamaged to get gallery1 to work as desired i.e. show distinct regions
I have, whoever not succeeded in creating a version of gallery2 that shows only the distinct values of the column team

I have managed to put gallery 3 together based on the value chosen in gallery 2.

Thank you for your assistance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Hello,

I am partially bald just from frustration hehe so don't worry we'll help you.

I am assuming region is a Text value, since you have Region Code and you didnt say what you put in gallery 1, so i am assuming Region (Text) not Code. I am also assuming its a single value. Please do not tell me its a mutiselect choice or I will be bald 🙂

Ok let's see you have columns
HireType, Division, Region, RegionCode, Team, TeamCode, Title, TitleCode

Now in my example SharePoint List I have

Title is NOT unique and is Text, so I will emulate your Region by filtering Gallery 2 by the unique value selected in the dropdown of Titles

And I do that by this
1. Filling a dropdown with unqiue Titles
2. Then this filter in Gallery 2
now before I apply the filter you can see my drop down and the Gallery(2) has all in them not just Refrigerator

Now I apply the Filter to Items
And now my Gallery2, which is based on the Selection from a dropdown based on a Distinct list of NON Unique Strings (Titles) aka Regions and shows the Invoice aka Teams

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TJCappy ,

I believe Items of Gallery1 is:

Distinct(ListA, Region)

then Items of Gallery2 would be:

Distinct(Filter(ListA, Region = Gallery1.Selected.Value), Team)

and Items of Gallery3 would be:

//Filter another list and get items that Team/Title equal to selected Team in Gallery1 Filter(ListB, Team = Gallery2.Selected.Value)

Best regards,

Was this reply helpful? Yes No

Join the conversation