cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Cascading Dropdown in Model-driven App Form

With all the customization options in powerapps, it seems as though a cascading dropdown in a model-driven app form should be easy. 

 

Looking for a way to filter regions - the user selects a country, and then the regions dropdown only shows regions in that country (If the user selects USA, regions dropdown shows US states, if the user selects Canada, regions dropdown shows Canadian provinces)

 

Thanks!

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Cascading Dropdown in Model-driven App Form

Hi @Anonymous ,

Do you want to configure a cascading dropdown in a model-driven app form?

 

If you want to configure a cascading dropdown in a model-driven app form, I afraid that there is no way to achieve your needs in PowerApps currently. Cascading Dropdown functionality is not supported within Model-Driven app form.

 

If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

As an alternative solution, you could consider embed an canvas app within your Model-driven app form. Then use the embedded canvas app to add data to your CDS Entity. Within the embedded canvas app, you could configure a cascading dropdown functionality between the Region Dropdown box and the Country Dropdown box.

More details about embedding an canvas app into a Model-Driven app form, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/announcing-the-general-availability-of-embedded-canvas-apps-in-model-driven-forms/

 

Please consider take a try with above alternative solution, then check if it could help in your scenario.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tiamo_Liu
Regular Visitor

Re: Cascading Dropdown in Model-driven App Form

Is this feature still not supported in model-driven apps?

EricRegnier Solution Sage
Solution Sage

Re: Cascading Dropdown in Model-driven App Form

Hi @Tiamo_Liu,

There are several tricks to get that work as per below, but unfortunately cascading optionsets are not supported out-of-the-box.

  1. Use entities instead. This is always my preference as entities give more flexibility, especially if eventually you need more properties/fields to the drop down items (e.g. Display Order). Using entities, you can filter out-of-the-box the related drop down/lookup/list on the form.
  2. Define the values of your optionset items with a prefix, then with JavaScript, filter the child dropdown based on the selected parent. For example:
    1. Parent optionset:
      • item 1: 11001
      • item 2 11002
    2. Child optionset:
      1. item 1: 11001001
      2. item 2: 11001002
      3. item 3: 11002001
      4. item 4: 11002002

Hope this helps

Tiamo_Liu
Regular Visitor

Re: Cascading Dropdown in Model-driven App Form

Hi @EricRegnier , sounds reasonable, thank you! 😉

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Users online (7,555)