How to Build Model Driven Apps Cascading Lookups in Dataverse 🙅🏻‍♂️

Learn how to build cascading lookups in Dataverse that can be used by Model-Driven apps or Power Pages. Have you ever wanted to select an account and only see contacts in that account or only cities in a given state or province. This method will show you how to accomplish that in less than 10 minutes.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#powerapps, #powerautomate, #BrianKnight, #powerplatform

[melsky]

This is a great set of video for Power Page, surely my first introduction and I am loving it. May just request that you update/refresh your play list to include all your other related videos and finally to sequence them so viewers don't have to go around looking for the other videos not in the playlist. Many thanks.

[Loves-fy]

Thank you for this! Is there a way to have the dropdown automatically show the related records without also clicking on the magnifying glass? That seems like something many people would not do. Might generate lots of questions.

[withamla]

I found this very helpful! One issue that I have found is when I change the column with the controlling value, the previous value still remains in the dependent column. Is there any way to clear out the dependent column value and require the user to reselect the dependent value? Eg. If i change the company, the contact needs to be re-selected.

[headflask]

This was cool beans. Next up for me is organizing all the view edit create forms for my power page. Video?

[mtamitolanga]

Thank you, been switching to classic and never realised its been added in the modern look 👌👍. I have 4 lookups cascading/filtering, is there another way of controlling the On Change instead of the business rule, so that if the parent changes then the child is cleared. Thanks

[ikponmwosaaikhionbare]

Please where can I find the video where you set up the tables to allow cascading lookups?

[michaellock]

To be clear - this solution uses tables (i.e. tables that must be developed), not the built-in choice/choices functionality for dropdowns. This is fine but I think it's important that people understand the difference. The value in choice/choices is that PowerApps builds/manages the data storage functionality automatically (but does not support cascading drop-down functionality, at the time of this writing). In this solution the developer must create the tables.

[kaylategeler]

Why don't my custom relationships show up in the filter dropdown? Please help :-)