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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
WarrenBelz 156,055 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,055 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Steggsy17 71 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No