web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown On Select not...

Power Apps

Answered

Dropdown On Select not working properly

(0) Share

Report

Report

Posted on by schwibach

2 Moderator

Hello,

I'm trying to do cascading dropdowns on Lookup columns in a Sharepoint list.

A teacher selects one of the schools where he works (filtered dropdown column), then he gets in the next dropdown all the classes at that school that he teaches... as a result, he will get a gallery with his students.

I created collections for both the schools and the classes.

The first collection is filtered for the teacher, the second for the teacher and the school.

I clearcollect the collections OnChange and OnSelect of every dropdown.

What's odd is: when I select a different school, the selection in classes does not change. But when I click the value in the first dropdown, it will change.

I set a variable to the selected value in the dropdown, and it changes only when I click the Dropdown again (!) hafter changing it.

I'm at a loss how to deal with this.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @schwibach ,

Please try:

1\ Move the collect schools collection to OnVisible of this screen, set schools dropdown Items to this collection

2\ Set OnChange of the schools dropdown to create the classes collection

3\ Use classes collection in Items of classes dropdown.

4\ User classes dropdown selected value to filter the students gallery.

OnSelect property would be triggered when you tap/click on a control.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
schwibach 2 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
ClearCollect(colKlassen;Filter(Corona_Test_Lehrer_in_Klassen;Lehrer.Email=varUserEmail;Schule.Value=Dropdown_Schule_Test_erfassen.Selected.Result).Klasse);; ClearCollect(colTests;Filter(Corona_Test_Schüler;Klasse.Value=Dropdown_Schule_Test_erfassen.Selected.Result;Schule.Value=Dropdown_Klasse.Selected.Result));; //Set(varSchule;Dropdown_Schule_Test_erfassen.Selected.Result);; //Set(varKlasse;Dropdown_Klasse.Selected.Result);;

I did exactly that and it's working. For some weitd reason, it doesn't work if I keep the Set variables functions in. Any ideas why that is?
Or should I use a different function to keep these values for other screens?

Join the conversation