Author Details

avatar-teacher

Evolvous

We are a team of tech enthusiast and this section is where we love to share our experience and our knowledge. We try our best to help you understand technical topics by giving you live instances of how-to’s, guides, tips, FAQ’s and troubleshoots.

If you like it or have questions, do share your feedback in the comments section below.

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 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.

Cascading Dropdown - Evolvous

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.

Cascading Dropdowns in PowerApps - Evolvous

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.

Cascading Dropdowns in PowerApps - Evolvous

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

Distinct (Employee_Department, Title)

For the Employee Department dropdown - Evolvous

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

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

For the Employee Department dropdown - Evolvous

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

For the Employee Department dropdown - Evolvous

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.

Microsoft PowerApps component Library - Evolvous

I hope you found this blog helpful.