Cascading Dropdown In PowerApps

In this blog i have discussed about how to create cascading dropdown in PowerApps using SharePoint list.

Cascading dropdowns are a powerful feature in PowerApps that allows you to filter data by selecting one or more dropdown controls. This can be useful for many scenarios, such as selecting products based on categories or filtering data based on location.

In this blog, we will explore how to create cascading dropdowns in PowerApps using the SharePoint list.

Steps to create cascading dropdowns In PowerApps

Step 1

Create a SharePoint list with three columns: Manufacturer, Model, and Color.

Step 2

Create three dropdown controls on your app screen, one for car Manufacturer, one for car Model, and one for the car Color.

Step 3

Set the Items property of the Make dropdown to the distinct values in the Make column of your SharePoint list.

You can use the following formula in the Item property of the Manufacturer dropdown:

Distinct('CarDetails’, Manufacturer)

'CarDetails' is my SharePoint list name, and Manufacturer is the column name.

Similar to step 3, we will connect data to the remaining dropdowns.

To get the car models based on the selected Manufacturer, use the below formula:

Distinct(
    Filter(
        ‘CarDetails',
        Manufacturer=Dropdown1.Selected.Value
    ),
    ‘Car Model’
)

Then, select the Color dropdown and write this code in the Items property to display Colors for the chosen Model.

Filter(‘CarDetails’, Car Model = Dropdown2.Selected.Value)

Now we have a working set of cascading dropdowns.

Conclusion

Following the steps and tips outlined in this blog, you can create cascading dropdowns that meet your app's specific needs and help users interact more effectively with your data.