Answered

Filter two Comboboxes

(0) Share

Report

Posted on by luwu_7100

Hello together,

I try to built a gallery that can be filtered with two comboboxes ("ComboBoxStatus", "ComboBoxName").
Datasource is "List 1" and filtered columns are "status" and "name".
Multiple selections in each dropdown should be possible.

Can anyone help me with the function for filtering?

Thank you,

Lukas

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

TikshaAggarwal on at

Like (0)

Report
Copy link

Link copied!
Hi @luwu_7100 ,
Try this,
I'm assuming Status to be of choice type column here.
Filter('List 1',ComboBoxStatus.Selected.Value in Status.Value || ComboBoxName.Selected.Value in Name)
If you want to filter by both Name and Status combined, then replace Or || with And (&&) operator

Hope this helps,
Tiksha

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

This scenario you will have a delegation warning and this is the function:

Filter( 'List 1', status in ComboBoxStatus.SelectedItems.status || IsBlank(ComboBoxStatus.Selected.status), name in ComboBoxName.SelectedItems.name|| IsBlank(ComboBoxName.Selected.name) )

I considered both columns as text, but if status is a choice replace 'status' with 'status.Value':

Filter( 'List 1', status.Value in ComboBoxStatus.SelectedItems.status || IsBlank(ComboBoxStatus.Selected.status), name in ComboBoxName.SelectedItems.name|| IsBlank(ComboBoxName.Selected.name) )

let me know if you have any doubts or issues

Was this reply helpful? Yes No
luwu_7100 on at

Like (0)

Report
Copy link

Link copied!

Hey @victorcp , why do you put ".status" behind "ComboBoxStatus.SelectedItems"? Here I get an error that its invalid.

Was this reply helpful? Yes No
luwu_7100 on at

Like (0)

Report
Copy link

Link copied!

Hey Tiksha,
thanks for your idea. Unfortunatley it doesnt work because ".Value" in Status.Value is underlined red and says that text cant be used in this context.

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

it will depend on how you set the combobox items, could you share it here please? and also the columns types?

Was this reply helpful? Yes No
luwu_7100 on at

Like (0)

Report
Copy link

Link copied!

I set the combobox items with
Distinct('List 1', Status)
And in my sharepoint list its a choice column that does just allow one choice in each row.

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello,

so the formula will be this:

Filter( 'List 1', status.Value in ComboBoxStatus.SelectedItems.Value || IsBlank(ComboBoxStatus.Selected.Value), name in ComboBoxName.SelectedItems.Value || IsBlank(ComboBoxName.Selected.Value) )

I hope it helps 🙂

Was this reply helpful? Yes No
luwu_7100 on at

Like (0)

Report
Copy link

Link copied!

Hey @victorcp ,
I tried your formular, but ".value" from "status.value" is underlined with the information that powerapps can not convert datatyp from type text to type record.
And why du you use "status.value" for the first condition and just "name" without .value in the second?
Thanks,
Lukas

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello!

as you mention before, status is a 'Choice' column so to access the information stored in this column you have to select the property 'Value' and for 'Sigle Line of Text' columns it is not necessary that's why name is without 'Value'.

Regarding the error could you please take a screenshot of the formula and place it here? because I never see that error in this context

Was this reply helpful? Yes No
luwu_7100 on at

Like (0)

Report
Copy link

Link copied!

Hey, here is the error message. In my question I wrote "List 1" and "ComboBoxStatus" to make it easier to understand, thats why the names are a bit different here.
I tried it at first just with only one condition to make sure this works before i add the second ComboBox. Sorry for German syntax. The error means "This datatype can't be converted. PowerApps can't convert this data from "text" to "record".

Was this reply helpful? Yes No