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.
At first we need to create SharePoint List like,
The Manufacturer, Model, and Color columns should be included in a SharePoint list.
Create three dropdown controls on your app screen, one for car Manufacturer, one for car Model, and one for the car Color.
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:
When we place the formula om Manufaturer field it is automatically get the data from the SharePoint ,Because both are connected internally by Data.
The Formula for Manufaturer is
Distinct(‘Car Details’,Manufaturer)
‘CarDetails’ is my SharePoint list name, and Manufacturer is the column name.
we will connect data to the remaining dropdowns.
To get the car models based on the selected Manufacturer, use the below formula:
Distint(
Filter(
‘Car Details’,
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.
Now we have a working set of cascading dropdowns.
If we test the Application the results will be changes accordingly.
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.
For any Help or Queries Contact us on info@crmonce.com or +918096556344
