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.
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Brian30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/you...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZbin: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#powerapps, #powerautomate, #BrianKnight, #powerplatform

[@michaellock4833]

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.

[@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

[@PragmaticWorks]

No problem 👍

[@ikponmwosaaikhionbare5490]

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

[@deepikakbify]

I am searching for the same.

[@michaellock4833]

This is straight forward new table creation. 1) create a table that will contain the filtered/cascaded values you want to lookup 2) define a column that holds the value you want to lookup 3) define a column that references the "filtering" value e.g. if the value you want to filter is a list of states/provinces within a country that you select, this will be a reference to a table that contains the list of countries. 4) populate the table with the states/provinces you want to be able to look up. For each row, pick the country it is related to. Use this table as the source for your cascaded/filtered lookup.

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

[@kaylategeler218]

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

[@headflask]

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

[@melsky316]

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.

[@PragmaticWorks]

Will do!

[@habamoise4771]

Interesting, Thanks

[@jasonjacome5963]

Thanks for sharing❤