Showing results for 
Search instead for 
Did you mean: 
New Member

Cascade dropdowns in model driven apps

I have these two entities who are related (one order: multiple products):





Owner (Values come from the Owners entity, based on the Facility)




ProductType (I need these values to be filtered based on the facility from Order entity)


I created a model driven app and it works great; however how can i filter the ProductType values based on the Facility choosen?

I can filter the owner values based on facility because they are part of the same entity (using the related records filtering property of the field); but the ProductType is in a different entity than the Facility field; how can i filter values to create a casacde dropdown?



Super User II
Super User II

Hi @MsMicrosoft 

I have been experimenting with Model driven apps for a few months but I am not an expert.  I don't believe that you can use cascading dropdowns.  However, you can use a Subgrid on a form to show related items in a different entity as long as the child entity (Products) uses a many to one relationship to the parent (Orders).

Not applicable

Would you mind linking to an article or video that has instructions for this? Thanks!

Hi @Anonymous 

I have found very little on this feature and most of what I learned was by trial and error. This is a reference starting point. I get the feeling that embedding a canvas app into a MDA is probably the way to go but I haven't gotten around to exploring that.  There are quite a few references for this in recent months and a few videos as well.  

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Kudoed Authors
Users online (47,130)