Cascading (dependent) Dropdowns

(0) Share

Report

Posted on by Venqui

Hello,

I would like to filter my second dropdown by the first one. Beside this, both should filter my gallery.

I have collections on my screen
OnVisible:

ClearCollect(Collect_customer, {Value: "Show All"});
ClearCollect(Collect_Factor_name, {Value: "All"});
Collect(Collect_customer, Distinct(Factors, Customer));
Collect(Collect_Factor_name, Distinct(Factors, Factor));

First dropdown which is sorting by "Customer":
Items:

Sort(Collect_customer,Value,SortOrder.Ascending)

Second dropdown which is sorting by "Factor":
Items:

If(
 Customer_dropdown.Selected.Value = "Show All", Collect_Factor_name,
 Customer_dropdown.Selected.Value <> "Show All", Filter(Collect_Factor_name, LookUp(Factors, Factorid = ThisRecord.Factorid, Customer) = Customer_dropdown.Selected.Value)
)

It is working pretty well on "Show All" , I have a full list of possible factors:

But when I choose first specific "Customer" I got same result as "Show All" even with factors booked for another customer.
When I select another specific customer, Factor dropdown is empty. Look at below screen.

I assume that my second condition in IF function is not working correctly, but I didn't get any warnings. So, it is hard for me to understand what is wrong with this.

Thank you in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Venqui 32 on at

Like
a
(0)

Report
Copy link

Link copied!
OK, I made some adjustments.

It is working with:
If( Customer_dropdown.Selected.Value = "Show All", Collect_Factor_name, Customer_dropdown.Selected.Value <> "Show All",Distinct(Filter(Factors, Customer = Customer_dropdown.Selected.Value), Factor) )

So, my other question is how to add "All" to those factors to be able show all factors assigned to particular customer?

Was this reply helpful? Yes No
Verified answer

Venqui 32 on at

Like
a
(0)

Report
Copy link

Link copied!
I found a solution. I used Ungroup() and Table() function to add "All" option to my dropdown (without creating a collection). So the "All" option was added to Filtered options based on first dropdown.

Factor Dropdown Items:
Sort( If( Customer_dropdown.Selected.Value = "Show All", Sort(Collect_Factor_name,Value, SortOrder.Ascending), Customer_dropdown.Selected.Value <> "Show All", Ungroup( Table( {DropdownOptions: ["All"]}, {DropdownOptions: Distinct(Filter('backoffice.Factors', Customer = Customer_dropdown.Selected.Value), Factor)} ), "DropdownOptions" ) ), Value, SortOrder.Ascending )

Was this reply helpful? Yes No