Power Apps

Making dropdowns dependent on each other

(1) Share

Report

Posted on by ccqn

205

Hi all,

I have a gallery that I am filtering by 4 dropdowns and 1 search bar

Is it possible to make it such that if Customer A is selected then the other dropdowns will only have the values which has Customer A and vice versa for all 4 filters?

E.g.
Dept Customer

1 B

1 A

2 A

3 B

Only 1 and 2 would show up in the Department dropdown.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

CU25020938-0

71 on at

Like (0)

Report

Copy link

Link copied!

Hi,

Considering that Customer is the lowest in the hierarchy you need a row for every customer, like this:

Department	Zone	AC Type	Customer
1	Zone1	AC Type 1	Customer 1
1	Zone2	AC Type 2	Customer 2
1	Zone3	AC Type 1	Customer 3
1	Zone4	AC Type 2	Customer 4
2	Zone5	AC Type 1	Customer 5
2	Zone6	AC Type 2	Customer 6
2	Zone7	AC Type 1	Customer 7
2	Zone8	AC Type 2	Customer 8
3	Zone9	AC Type 1	Customer 9
3	Zone10	AC Type 2	Customer 10
3	Zone11	AC Type 1	Customer 11
3	Zone12	AC Type 2	Customer 12
4	Zone13	AC Type 1	Customer 13
4	Zone14	AC Type 2	Customer 14
4	Zone15	AC Type 1	Customer 15
4	Zone16	AC Type 2	Customer 16

Then your department dropdown will be (items property)
Distinct(YourList,Department)

Zone dropdown will be:

With(

    {Keyword: DepartmentSelector.Selected.Value},

    Filter(

        YourList,

        Department= Keyword

    ).Zone

)

AC Type will be:

With(

    {Keyword: ZoneSelector.Selected.Value},

    Filter(

        YourList,

        Zone= Keyword

    ).'AC TYPE'

)

Customer dropdown will be:

With(

    {Keyword: ACTYPESelector.Selected.Value},

    Filter(

        YourList,

        'AC TYPE'= Keyword

    ).Customer

)

Was this reply helpful? Yes No

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi ccqn,

Making dropdowns dependent can only happen in one direction not vice versa cause that will error due to Circular Reference.

If you want the first three dropdowns to be dependent on the "Customer" dropdown. Then you can modify the Items property of your dropdowns like this:

If( !IsBlank(CustomerDropDown.Selected), Distinct( Filter( DataSource, Customer= CustomerDropDown.Selected.Value ), Dept ), Distinct( DataSource, Dept ) )

Modify the above code for the other dropdowns.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No