Announcements
["A", "B", "C", "D"]
["E", "F", "G", "H"]
Switch( firstdrpdown.Selected.Value, "A", ["E"], "B", ["F"], "C", ["G"], "D", ["H"] )
using the Switch function in Power Fx, We Can Achive this
In the OnChange property of the first dropdown (let’s call it Dropdown1):
Dropdown1
Switch( Dropdown1.Selected.Value, "A", "E", "B", "F", "C", "G", "D", "H", "" )
Dropdown2
Table({Value: Switch(Dropdown1.Selected.Value, "A", "E", "B", "F", "C", "G", "D", "H")})
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 339 Most Valuable Professional
11manish 180
MS.Ragavendar 88 Super User 2026 Season 1