Filter data for Combobox

(0) Share

Report

Posted on by vecerpa

786

Hello all,

I'm looking for some option, if there is any, to filter Items for Combobox. I have data table where I have multiple columns like Area, OrgUnit, Country... First I'd like to preselect with Dropdown Area and based on this I'd like to allow search in Combobox over column OrgUnit as there is plenty of lines.

There is maybe some another way how to solve this, but I don't see it...

Thank you for your help.

Pavel

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You can list all Distinct areas in the dropdown control, and use a Filter to limit the items from the combobox.

For example, if your data source is called Orgs, then you can have the following expressions:
Dropdown1.Items: Distinct(Orgs, Area) Combobox1.Items: Filter(Orgs, Area = Dropdown1.Selected.Result) Combobox1.DisplayFields: ["OrgUnit"] Combobox1.SearchFields: ["OrgUnit"]

Was this reply helpful? Yes No
vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CarlosFigueira,

It seems like this is not working, so I will go to detail.
I have imported excel file - OrganizationUnit, here I have Area and Name, I'd like to filter by Area (DropDown) and Display and Search on Name (Combobox).
I used for combobox:
Filter(OrganizationUnit_1;Area = DropdownArea.Selected.Result)
But there is displayed error: There was expected operator (for example +,*,&&).

So do you have some other suggestion?
Have nice day
Pavel

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It turns out that you're hitting a bug in the combobox control that doesn't happen in English (which is why I didn't see it when I tried). When I opened the Web Studio in Czech, I see the same error as you do, even for the same app.

I've reported this bug to the owner of that control. One possible workaround for now is to consider using the English version of the authoring, by appending ?l=en-US in the web authoring page (https://create.powerapps.com/studio/?l=en-US). Not ideal, as you may need to explicitly set the formatting for your locale, but it may help for now.

@miglisic may know of some other workarounds for this problem.

Was this reply helpful? Yes No
Jeremy_Rodgers Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Here is a possible mitigation for you to try:
instead of:
Combobox1.Items: Filter(Orgs, Area = Dropdown1.Selected.Result)
try this:

Combobox1.Items: Filter(Orgs, Area = Dropdown1.Selected.Value)
We're continuing the investigation around the error resulting from the original formula that you reported.

Thanks,
Jeremy

Was this reply helpful? Yes No
vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CarlosFigueira is there a chance to share with some expected date to fix this bug? It will be nice to have some date in hands 🙂

BR
Pavel

Was this reply helpful? Yes No
vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jeremy_Rodgers both have same issue. I'm not able to filter in combobox.
Pavel

Was this reply helpful? Yes No
Meidhi_78410 4 on at

Like
a
(0)

Report
Copy link

Link copied!
try
Combobox1.Items: Filter(Orgs, Area in Dropdown1.SelectedItems.Result)

Was this reply helpful? Yes No
vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jeremy_Rodgers,
It looks like that this bug was fixed and it is working as I expected. I am able to filter items for combobox with selected item in dropdown and search in such filtered items...
Can you confirm this?
P.

Was this reply helpful? Yes No
eopara 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Still doesn't work... Please help look into this...

Was this reply helpful? Yes No
eopara 130 on at

Like
a
(1)

Report
Copy link

Link copied!

Still doesn't work... Please help look into this...

Was this reply helpful? Yes No