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

Dependent Choice list in Dataverse (Common Data Service )

Hello Everyone,

 

Is there an option in cds to make a dependent dropdown list? For example, if we select country and the second combo box should only show the states of the selected country (narrow down). I could not get the solution anywhere in the internet. So expert please advice!

 

Thanks in Advance,

Nizam

2 REPLIES 2
summitb
Memorable Member
Memorable Member

Hi @Anonymous ,

You can't do with Choice but you can do it with lookUps using Pre-Filtering and Post-Filtering

 

How to Filter Lookups Without Custom Code in Dynamics 365 Customer Engagement (arbelatech.com)

EricRegnier
Super User
Super User

Hi @Anonymous,

There are two main methods to achieve this depending on your data model, but unfortunately cascading choices/optionsets are not supported out-of-the-box.

  1. 1st simple out-of-the-box method is by using lookups on tables/entities instead of optionsets. 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. Here are the steps with Category, sub-category as an example:
    1. In make.powerapps.com, navigate to your Entity --> Forms and open the desired form
    2. Switch to Classic form designer by clicking the "Switch to Classic" button in the command bar
    3. Select the lookup field and click "Change Properties" in the ribbon
    4. Under the "Related Records Filtering", check "Only shows records where"
    5. Pick the Category lookup field in the dropdown then in "Contains" the Category related field
      2020-10-14_20-51-54.png
    6. I would uncheck "User can turn off filter" so users can't turn off and pick un related sub-categories
    7. Click OK, Save All and Publish

      Note: a small caveat is that it expects the main Category to be selected before the sub-category.

  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!

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (1,688)