How to set a dropdown based on another dropdown?

[Trish00]

I have 2 dropdowns with different values, one of the fields will be visible for users and the other one will be set to be invisible for tracking and management purposes.

Dropdown 1 - Yes, no, Pending

Dropdown2 - Yes, No , TBD

How can I update Dropdown2 to automatically update when selection is made.

Dropdown1 Yes = Dropdown2 Yes

Dropdown1 No= Dropdown2 No

Dropdown1 Pending = Dropdown2 TBD

[eka24]

Assuming you have a collection which is on the Items property of the dropdowns:

ClearCollect(Mylist,[ "Yes", "no", "Pending","TBD"])

Put the Mylist on the Items property of the 2 dropdowns.

Then In Default property of Dropdown2:

If(Dropdown1.Selected.Value ="Pending","TBD", Dropdown1.Selected.Value)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel

[AsanKani]

Hi, @Trish00 

Your dropdown1 items property to set ["Yes","No","Pending"]
Your dropdown 2 item property to set["Yes","No","TBD"]

Your dropdown 2 default property to below coding set  If(Dropdown1.Selected.Value="Yes","Yes",If(Dropdown1.Selected.Value="No","No",If(Dropdown1.Selected.Value="Pending","TBD")))

Based on above formula you can change or extend your dropdown items like "Yes","No","Pending", "Inprogress","Approved","Maybe" like what every you need to extend your data source. same as followed if statement in your default property to update what every you need.


Please click Accept as solution 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 or you liked the post and want to show some appreciation, please give it a Thumbs Up.

[AsanKani · Accepted solution]

Hi @Trish00 
Dropdown 1 items property ["Room1", "Room2", "Room3", "Room4", "Room5"]

Dropdown 2 items property ["1","2","3","4","5"]

Dropdown 2 default property 

If(Dropdown4.Selected.Value="Room1","1",If(Dropdown4.Selected.Value="Room2","2",If(Dropdown4.Selected.Value="Room3","3",If(Dropdown4.Selected.Value="Room4","4",If(Dropdown4.Selected.Value="Room5","5")))))

I hope now your problem resolved. Give thumbs up for appreciate my reply.

Please click Accept as solution 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 or you liked the post and want to show some appreciation, please give it a Thumbs Up.