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

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

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

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

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

[@jasonjacome5963]

Thanks for sharing❤

[@kaylategeler218]

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

[@habamoise4771]

Interesting, Thanks

[@headflask]

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