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.
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.
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.
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.
I hope you found this blog helpful.