using the Switch function in Power Fx, We Can Achive this
In the OnChange property of the first dropdown (let’s call it Dropdown1
):
Switch(
Dropdown1.Selected.Value,
"A", "E",
"B", "F",
"C", "G",
"D", "H",
""
)
Dropdown2
) to this formula:
Table({Value: Switch(Dropdown1.Selected.Value, "A", "E", "B", "F", "C", "G", "D", "H")})
["A", "B", "C", "D"]
["E", "F", "G", "H"]
Switch(
firstdrpdown.Selected.Value,
"A",
["E"],
"B",
["F"],
"C",
["G"],
"D",
["H"]
)