Answered

Filtering for Cascading Drop Down

(0) Share

Report

Posted on by automan25

In a PowerApp application I have a form based on a SharePoint list. On that form are two comboboxes, one to select a U.S. state and one for U.S. counties. In the associated SharePoint list the State column is a choice column, and the Counties column is a lookup column which connects to another SharePoint list that contains all of the counties in Alaska, Idaho, Oregon, and Washington in one column and their associated state in another. I would like to have the counties combobox filter based on the state that is selected in the state combobox. This code, placed on the Items parameter of the Counties combobox has gotten me part of the way there.

Filter(Choices([@Subrecipients].County), Value in Filter(Counties, State = StateField.Selected.Value).Title)

The issue I'm having is that I'm getting duplicate values for states that each have a county of the same name. For example, both Washington and Idaho have a Jefferson county. Hence, Jefferson shows up twice in the filtered Counties combobox.

Any ideas what might be going on here?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

IsabellaFranco 44 on at

Like (0)

Report
Copy link

Link copied!

I think that GroupBy will work. See this: GroupBy and Ungroup functions in Power Apps - Power Platform | Microsoft Learn

In fact, I ended up here because I was looking for the Filter function, I think that this version of powerapps has a problem with the filter function, because my results are not displayed to users when I use the filter. Let me know if you are also having this problem.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
@automan25,

You could check whether the Id field is in the .ID array instead of checking for name. Since name is not unique, both the example of Washington and Idaho will return true to your Filter condition causing duplicates. Working with the unique ID will prevent this:

Filter( Choices([@Subrecipients].County), Id in Filter(Counties, State = StateField.Selected.Value).ID )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
automan25 74 on at

Like (1)

Report
Copy link

Link copied!

That did the trick. Thanks so much! A second set of eyes so often helps.

Was this reply helpful? Yes No