Answered

Dropdown lists update, when either is selected

(1) Share

Report

Posted on by Steggsy17

Hi Experts,

I have two dropdown lists and would like them to update, when you select one of them just like in excel if you were using a filter.

For example if you selected Test 1 = 1, then the only available option in Test 2 would be 1

And vice versa, if you selected Test 2 = 1, then the only available option in Test 1 would be 1.

So you can select both ways and they update each other.

Test 1	Test 2
1	1
2	2
3	3
4	4
5	5

I've seen many articles, where you can cascade so if I select Test 1, then Test 2 updates... but not working both ways if you selected Test 2 first, then Test 1 updates?

Any advice, would be greatly appreciated thank you

Categories:

Using Apps Using Formulas

General Questions

Dataflows

All responses (4)

Answers (1)

Steggsy17 71 on at

Like (0)

Report

Dropdown lists update, when either is selected

Thanks @ WarrenBelz, variables example below, certainly helped with the logic for this.

Many thanks

It won't let me select your actual logic reply as the, "Does this answer your question?"

Cheers
Verified answer

WarrenBelz 146,660 Most Valuable Professional on at

Like (0)

Report

Dropdown lists update, when either is selected

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
WarrenBelz 146,660 Most Valuable Professional on at

Like (1)

Report
Dropdown lists update, when either is selected

Hi Steggsy17

You can do it using Variables - put this at Screen OnVisible or anywhere else you need to reset it.
UpdateContext( { var1: Blank(), var2: Blank() } )

then OnChange of each - example for first
UpdateContext({var1: Self.Selected.Value})

then the Items (the reverse will apply for the second drop-down)
If( IsBlank(var2), ["1","2","3","4","5"], [var2] )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report

Dropdown lists update, when either is selected

Hi Steggsy17,

This would create a circular reference which is not allowed in Power Apps.

Even if you tried to display DefaultSelectedItems both ways, it will still result in a Circular Reference.

I would suggest descoping this requirement if its just a good to have functionality.

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!