Duplicate values or no values in Cascading Dropdown boxes from a Sharepoint List in a FORM

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have two cascading dropdown boxes in a form, let's just call them State and City. My Sharepoint List is named SharepointList and the list that contains the cascading values is called CascadingList. The City dropdown box is dependent on the State dropdown box. Initially, I was getting a bunch of duplicate values in the State dropdown box but I believe I have that resolved by adding the Distinct control, so it looks like this Distinct(Choices([@'Sharepointlist'].'State'),Value). I'm only mentioning it in case it's the source of the problem.

When I click on the City dropdown box I see a bunch of blank values and only one city. I have "Filter('SharepointList', 'State' = StatesDropDown.Selected.Value) in the ITEMS property. Does anyone know how to fix this problem?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

For the cascading Dropdown, Items should be:

Filter('CascadingList', 'State' = StatesDropDown.Selected.Value)

Best regards,

Was this reply helpful? Yes No