Unanswered

Display dropdown2 values by filtering other dropdown2 using collect function

(0) Share

Report

Posted on by JHChoi81

FixtureNum	FixtureName
0001	Torque
0002	Wrench
0003	Pump
0004	Pump
0005	Torque
0006	other

I have one table.

> Screen

-> OnVisible fx:

   ClearCollect(collectA, {Result : "All"});
   Collect(collectA, Distinct(FixtureMasterList,FixtureNum));
   ClearCollect(collectB, {Result : "-"});
   Collect(collectB,Distinct(FixtureMasterList,FixtureName));

Dropdown1

-> Item fx : collectA

Dropdown2

-> item fx : collectB

So, If i choice the dropdown2, i want to filter dropdown1 based on dropdown2.

ex) Selecte "Torque" (in dropdown2),

dropdown1 displays "0001 , 0005"

Plz save me..

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

For dropdown1, set the Items property to:

Filter(FixtureMasterList, FixtureName = Dropdown2.Selected.Result)

Let me know if this works.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
JHChoi81 51 on at

Like (0)

Report

I am sorry to say that,
the filter is not working
dropdown2 : default "All"
Item : Filter(FixtureMasterList,FixtureName=ddFixtureName.Selected.Result) /*ddfixtureName=dropdown2

I want to use filter with "collectA".
Is there way ?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

When you say it's not working, what is the behavior you are getting? I tested this out and it works perfectly fine. You can modify it slightly to show all values when dropdown2 is set to All by using this:

Filter(FixtureMasterList, FixtureName = Dropdown2.Selected.Result || true)

If you are final desired outcome is to have a dropdown of Fixture Numbers filtered down based on the Fixture Name selected, you dont need Collection A.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No