cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BJoshi
Helper I
Helper I

Configure Cascading Dropdown in Model-driven App

Hello Everyone,

I have created 3 tables in Dataverse,
1. Country
Column - Name (Single Line Text)

2. State

Column - Name (Single Line Text), Country (Lookup)

3. City
Column - Name (Single Line Text), State (Lookup)


I need to configure Cascading Dropdown for City. For example, if the end-user selects any country, the state dropdown options should be filter-based selected Country, then the end-user selected the state city dropdown should be a filter-based selected State.


Can anyone suggest me for the same?

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@BJoshi 

You need to do so through the classic interface

So after adding your lookups to the form -> Click Switch to Classic

Mira_Ghaly_0-1629092648352.png

Double Click on the State field; this will open the field properties dialog

On the Enable Records Filtering Click on Only Show Records when

 

Mira_Ghaly_1-1629092787012.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

1 REPLY 1
Mira_Ghaly
Dual Super User
Dual Super User

@BJoshi 

You need to do so through the classic interface

So after adding your lookups to the form -> Click Switch to Classic

Mira_Ghaly_0-1629092648352.png

Double Click on the State field; this will open the field properties dialog

On the Enable Records Filtering Click on Only Show Records when

 

Mira_Ghaly_1-1629092787012.png

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,963)