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.
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"]
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
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.
Here is a possible mitigation for you to try:
Combobox1.Items: Filter(Orgs, Area = Dropdown1.Selected.Result)
Combobox1.Items: Filter(Orgs, Area = Dropdown1.Selected.Value)
We're continuing the investigation around the error resulting from the original formula that you reported.
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?
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand