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

All responses (6)

Answers (1)

Sort by

hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

Problem solved , you are my hero this moring THNX .
AC1 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@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
OrangeJuiceCup 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Check that you've chosen the desired column in the Default property for your data cards.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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....