You might consider using the "Items" property of DropDownLists and Radios instead of OnChange.
Here is the Datamodel is used:
ClearCollect(
Country,
{CountryName: "India"},
{CountryName: "Srilanka"},
{CountryName: "Nepal"},
{CountryName: "Fiji"}
)
ClearCollect(
CountryState,
{CountryName: "India", StateName: "Maharastra", Cities: "Pune;Nashik;Nagpur" },
{CountryName: "India", StateName: "Gujraat", Cities: "Ahmedabad;Surat;Vadodara;Rajkot" },
{CountryName: "India", StateName: "Karnataka", Cities: "Banglore;Hubli" }
)
Let's say your first ddl "DropDownListCountry" has Items : Country.
Then the "Items" property of the second ddl "DropDownListState should be :
Filter(
CountryState,
CountryName = DropDownListCountry.Selected.CountryName
).StateName
And the "Items" property of your radio buttons control "RadioCity" should be :
Split(
LookUp(
CountryState,
StateName = DropDownListState.Selected.StateName,
Cities
),
";"
)
You have a good example of using the Filter function, to retrieve several entries according to a filter (the country name), and the Lookup function, to use a property of an item retrieved according to a filter (the state name).
Let me now if you need more explanations,
Cheers
Théo
