cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Trish00
Microsoft
Microsoft

How to set a dropdown based on another dropdown?

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

1 ACCEPTED SOLUTION

Accepted Solutions
AsanKani
Skilled Sharer
Skilled Sharer

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.

View solution in original post

3 REPLIES 3
eka24
Super User
Super User

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
Skilled Sharer
Skilled Sharer

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
Skilled Sharer
Skilled Sharer

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,531)