Dependent drop downs don't show values in the middle of the list

(0) Share

Report

Posted on by fluffyllamas

I am rather new to canvas apps. I have a dropdown called dealer and a drop down called location.

I have a table in sharepoint that is linked to these dropdowns.

The share point table has dealer column and location column and looks like this:

Dealer location

A Chicago

B LA

B San Francisco

C Atlanta

C Orlando

C Kansas City

The two boxes work perfectly. When I select B in Dealer Group I get LA and San Fran, But when I pick C in Dealer group I don't get anything in the dealer location. If I pick values in Dealer Group after C they work good too. Strangest thing ever.

What am I doing wrong? Why don't the values for dealer location show when I pick C? Everything else works perfectly.

Here is the code snip from the items property in dealer location:

Filter(ContactAppTable, Dealer = DealerDropDown.SelectedText.Value)

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @fluffyllamas ,

Your code is structurally correct, although SelectedText is deprecated.

Filter( ContactAppTable, Dealer = DealerDropDown.Selected.Value ).Location

How many records in the list and I assume both Dealer and Location are a Single Line of Text fields ?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

fluffyllamas

4 on at

Like (0)

Report

Copy link

Link copied!

Hi, there are 22 rows in the data sheet. see below:

Dealer Location

Dealer 1	Fort Worth
Dealer 1	Enid OK
Dealer 2	All
Dealer 3	Fresno
Dealer 4	Des Moines
Dealer 5	TN
Dealer 6	Atlanta
Dealer 6	Orlando
Dealer 6	Kansas City
Dealer 6	Alabama
Dealer 7	Unknown
Dealer 8	Columbus
Dealer 9	Nashville
Dealer 10	Boise
Dealer 11	Memphis
Dealer 11	MS
Dealer 12	El Paso
Dealer 12	Forest Park
Dealer 12	Houston
Dealer 12	Austin
Dealer 12	Phoenix

Dealer 6 doesn't display the locations when selected. All other dealers do.

Weirdest thing ever - but needs to be fixed. I changed the selectetext but it didn't make any difference.

Was this reply helpful? Yes No

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@fluffyllamas ,

SelectedText still works - I was just pointing out the current syntax. What is the Items of your drop-down ?

Was this reply helpful? Yes No
fluffyllamas 4 on at

Like
a
(0)

Report
Copy link

Link copied!

the items property is
Filter(ContactAppTable, Dealer = DealerDropDown.SelectedText.Value)

Was this reply helpful? Yes No
WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@fluffyllamas ,

I meant the Items of the drop-down, not the gallery.

Was this reply helpful? Yes No