Cascading Dropdowns in PowerApps

Cascading Dropdown in PowerApps means one dropdown control value depends on the previous selection in a hierarchy, i.e., when a user picks an option from one dropdown control, the values filter in another Dropdown control.

In PowerApps, there are some situations where we want a cascaded dropdown; hence in this blog, we will discuss how to create setups that leverage dropdowns cascading in PowerApps using the PowerApps platform with the SharePoint list as a data source.

Here we have two SharePoint lists with the following name:

1. Employee Department

2. Employee Details

In the Employee Department list, we have a column as Title, which is a single line of a text column, and it will store the name of the different departments as shown below image. This organization works perfectly for implementing PowerApps cascading dropdowns.

Employee Details is another SharePoint list where we have two columns as EmployeeName, which is a single line of text and will store the name of the employees and Another Column is a department column, which is a lookup column and looks to Employee Department List for displaying the name of the departments, as shown in below image. You can use the concept of Dropdowns cascading in PowerApps between these lists.

In this scenario, we want two dropdowns in the PowerApps; when I select the department’s name from the first dropdown, the other dropdown should automatically populate the names of the employees in that corresponding department. To achieve this functionality, below are the following steps. This setup is an example of creating cascading Dropdowns inside PowerApps solutions.

1. In PowerApps, I have added two drop downs as Employee Department and Employee Name. I have added the data source as Employee Department and Employee Details.

2. For the Employee Department dropdown, I have assigned the formula

Distinct (Employee_Department, Title)

3. For the Employee Name dropdown, I have assigned the formula

Filter(Employee_Details,Department.Value = ddnDepartment.Selected.Result).Title

4. After Saving and publishing the app, the result will look like this

Conclusion:

In the above blog, we discussed how to create cascading dropdowns using a SharePoint list as a data source and depending on the business need; we can implement it in the PowerApps. Clearly, if you need PowerApps cascading dropdowns, this method will help you achieve it efficiently.

I hope you found this blog helpful. For further questions regarding how to set up PowerApps with dropdowns cascading based on user selections, feel free to reach out.

=====

Plus read

Business Card Reader in Canvas Power Apps

Apply Custom Theme on Modern SharePoint Sites