Mastering Cascading (Dependent) Drop-Downs in Power Apps
📢Join the Your 365 Advisor Skool Community: https://www.skool.com/your365advisor
In this tutorial we will discuss how to create cascading drop-down lists in Power Apps. A cascading drop-down allows a choice in the first drop-down to filter the available choices in the second drop-down. They are also known as dependent drop-downs.
The scenario for this demonstration is, we have a Power App that allows people to submit a support request for various Microsoft applications. A user should be able to choose an application such as Teams, and then choose what functionality they need help with. When the request is submitted the data should be transferred to Microsoft Lists where the request will be tracked.
As part of the demonstration, we will create 2 Microsoft Lists to house the necessary data, set up the drop-down, set up a blank option to each list, and reset the drop-down after each submission.
Note: I am a Power Apps beginner and I had help coming up with the solution in this video. I read several support articles and asked questions of a wonderful coworker. I include a few tips to point out things that will help avoid errors.
If you have additional questions I encourage you to visit the Microsoft support forums or Microsoft Learn, where there is a lot of valuable information.
0:00 Cascading Drop-Downs
0:35 Required Information
2:12 Create App
2:59 Insert Drop-Down Boxes
4:25 Connect Data Sets
5:12 First Drop Down Formula
8:25 Second Drop Down Formula
10:26 Create Submit Button