cascading dropdown lists

(0) Share

Report

Posted on by dalacarelia_196

648

Hi Iam using 3 tables to make my dropdown lists working ( Color , Size and Type )

The first steps works i Find my color

I 2:nd Dropdown i can choose my type depending of color choise in dropdown 1

i 3:d i am trying to make choise of Size getting problem

And my code is

Filter((tblSizeChoise ;Color =ddColor.Selected.Value).Type && Type = ddType.Selected.Value).Size

In my tblSizeChoise i have all the filelds Color , Type and Size , but in my code i fid one value but right based on choise .

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

hpkeong 2,944 on at

Like (0)

Report

HI

I can't really read your picture but guess that your sequence is
- Dropdown 1 = Colour..Correct to use Distinct as it is a table for you to distinct
- Dropdown 2 = Type...Correcr to use Filter as it is a table for your to filter
- Dropdown 3 = Size...Incorrect to use because you need a RECORD.

So, for Dropdown 3 please change to LABEL and use LookUp - this is to find a SINGLE RECORD.

Hope this helps.

NB: Dropdown is bind to TABLE, not a single record.

Was this reply helpful? Yes No
Verified answer

v-micsh-msft on at

Like (0)

Report
Hi @dalacarelia_196,

Please take a try to modify the third dropdown with the code below:

Filter(tblSizeChoise ; Color =ddColor.Selected.Value; Type = ddType.Selected.Value).Size

This should make it work,

Regards,

Michael

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like (0)

Report

Problem solved , you are my hero this moring THNX .

Was this reply helpful? Yes No
AC1 2 on at

Like (0)

Report

@v-micsh-msft
HI, I'm able to setup the cascading dropdowns following you instructions. However, after I save and try to edit the record, the dropdown fields don't show what was saved. How can I correctly display the saved data?

Thanks
AC

Was this reply helpful? Yes No
OrangeJuiceCup 24 on at

Like (0)

Report

Check that you've chosen the desired column in the Default property for your data cards.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I am also facing the same issue ..i am not able to see the saved data from the cascading drop down column ...
after saving the form .it is showing the default drop down selection...
please can any one help here....

Was this reply helpful? Yes No