Hi @sbossler_079 ,
Do you want to set up your cascading Dropdowns 2 through 4 based on the Dropdown1?
Based on the needs that you mentioned, I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Dropdown1 to following:
ShowColumns('SQL Database'; "column"; "ID")
Set the Items property of the Dropdown2 to following:
Distinct(
Filter(
'SQL Database';
ID = Dropdown1.Selected.ID
),
"Column2"
)
Set the Items property of the Dropdown3 to following:
Distinct(
Filter(
'SQL Database';
Column2 = Dropdown2.Selected.Result
),
"Column3"
)
Set the Items property of the Dropdown4 to following:
Distinct(
Filter(
'SQL Database';
Column3 = Dropdown3.Selected.Result
),
"Column4"
)
Please consider take a try with above solution, then check if the issue is solved.
Note: You could also apply Sort function to above Distinct formula as your previous formula mentioned
Best regards,
