Cascading Drop-downs in Canvas Power App

A cascading dropdown (or cascading dropdown list) is a user interface element that consists of a series of dependent dropdown menus. The options available in one dropdown are dynamically filtered based on the selection made in another dropdown. This interactivity helps users make more relevant selections and reduces errors by guiding them through a logical sequence of choices.

Scenario. Cascading Dropdowns for Country, State, and City

Objective

To create a Power Apps form that allows users to select a country, state, and city in a cascading manner, ensuring that only relevant options are displayed based on previous selections.

Step 1. Set Up SharePoint Lists

Country List

Name: Country
Columns
- Title (Single line of text): Country Name (e.g., USA, Canada)

State List

Name: State
Columns
- Title (Single line of text): State Name (e.g., Gujarat, Kerala)
- Country (Lookup): Lookup column referencing Country

City List

Name: City
Columns
- Title (Single line of text): City Name (e.g., Spandau, Ahmedabad)
- Country (Lookup): Lookup column referencing Country
- State (Lookup): Lookup column referencing State

Step 2. Create a New Power App

Open Power Apps and create a new app (Canvas app).
Add Three Dropdown Controls.
- Rename them to DropdownCountry, DropdownState, and DropdownCity.
Add the data sources ( Sharepoint and all three lists)

Step 3. Configure Dropdowns

Country Dropdown

Control: DropdownCountry
Items Property: Choices(Country.Title)
Label: "Select Country"

State Dropdown

Control: DropdownState
Items Property: Filter(State_1, Country.Value = DropdownCountry.Selected.Value)
Visible Property: !IsBlank(DropdownCountry.Selected.Value)
Label: "Select State"

City Dropdown

Control: DropdownCity
Items Property: Filter(City, Country.Value = DropdownCountry.Selected.Value && State.Value = DropdownState.Selected.Value)
Visible Property: !IsBlank(DropdownState.Selected.Value)
Label: "Select City"

Step 4. Save and Run the app

Run the App: Test the functionality by selecting a country, then a state, and finally a city.
Validation: Consider adding checks to ensure users cannot submit the form without selecting values from all dropdowns.

Conclusion

This setup effectively creates a cascading dropdown system in Power Apps using SharePoint lists. By following the outlined steps, users will be able to navigate through the dropdowns intuitively, ensuring that only relevant options are displayed based on their selections.

If you need further assistance or adjustments, feel free to ask!