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 cascading dropdowns in PowerApps using the SharePoint list as a data source.
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.
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.
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.
Distinct (Employee_Department, Title)
Filter(Employee_Details,Department.Value = ddnDepartment.Selected.Result).Title
I hope you found this blog helpful.