Let's assume you have 3 cascading dropdowns:
dropCountry, dropState, dropCity
Let's assume you have a list (e.g. SharePoint) of city, state, countries:
ID | City | State | Country
1 | Miami | Florida | USA
2 | Houston | Texas | USA
3 | New York City | New York | USA
4 | Albany | New York | USA
dropCountry.Items =
Sort(Distinct(myList, Country), Ascending)
dropState.Items =
Sort(
Distinct(
Filter(myList, Country=dropCountry.Selected.Result).
State
),
Ascending
)
dropCity.Items =
ShowColumns(
Filter(myList, State=dropState.Selected.Result &&
Country=dropCountry.Selected.Result),
"ID", "City"
)
When you create a popup, you can validate that the popup only appears when all dropBoxes have values. Once that condition is satisfied, a patch command could be applied like this:
Patch(myList, Defaults(myList)
{
City: textboxUserInput.Text,
State: dropState.Selected.Result,
Country: dropCountry.Selected.Result
}
)If you are using temporary collections, then you would need to execute a refresh of sorts. If you are working directly with the actual datasource, it is not necessary.
I know your project is probably different, but hopefully this gives you some ideas.
