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

CASCADING DROPDOWN WITH 3 COLUMNS

Hi Team,

 

I am trying to create a cascading dropdown with multlivel dropdown and i have been testing using the method as shown here.

 

https://www.youtube.com/watch?v=EJQZ0sv7zV8&t=827s


I have named my sharepoint list as Log tool and three supporting list for connection as log1,log2 and log3.

list used as follows

 

i have the got this final out put of the method as shown from the above video. 

 

However, datas from Region only is been shown and not in the other two fields (country and location). i see there is no data listed from the drop down. i do not know what is the issue that is causing the data not being shown.

 

Coding used:

log1.Region

SortByColumns(Filter(log2, Title = ddRegion.Selected.Value), "Country", SortOrder.Ascending)

Filter(log3, Title = ddcountry.Selected.Value && Region = ddRegion.Selected.Value)

 

Could some one help me here what i have missed to notice and rectify the mistake?

Thanks, priyaa @dhananjayanhari 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@dhananjayanhari 

What is the Title column in your filter?

Your photo of the data shows different column names.

Based on that photo, I would say your Items properties need to be more like this:

 

dropdown for Region Items property : log1.Region
dropdown for Country Items property :
SortByColumns(Filter(log2, Region = ddRegion.Selected.Value), "Country", SortOrder.Ascending) dropDown for Location Items property :
Filter(log3, Country = ddcountry.Selected.Value && Region = ddRegion.Selected.Value)

 

I hope that is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

3 REPLIES 3
Super User III
Super User III

@dhananjayanhari 

What is the Title column in your filter?

Your photo of the data shows different column names.

Based on that photo, I would say your Items properties need to be more like this:

 

dropdown for Region Items property : log1.Region
dropdown for Country Items property :
SortByColumns(Filter(log2, Region = ddRegion.Selected.Value), "Country", SortOrder.Ascending) dropDown for Location Items property :
Filter(log3, Country = ddcountry.Selected.Value && Region = ddRegion.Selected.Value)

 

I hope that is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

@RandyHayes 

 

Thank you for your reply. I dont seem this code helps me here. attached the image for your reference.

 

Could you explain me what do you refer as column title?

 

i am attaching the supporting list column fields and not sure what you are reffering to.

 

Please help to understand where i have missed some logical coding.

 

Thanks,

Priyaa

 

 

@dhananjayanhari 

Priyaa,

Since you are deailng with a DataCard, you most likely have a ComboBox as the control within that datacard.  

The syntax of your formula shows "country" and your photo of the data shows "Country".  Is the name of the column in your data source country or Country? That needs to be accurate.

You show a red X on the photo, can you let me know what the error message is on that?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (60,054)