Answered

Filter items in Combobox

(0) Share

Report

Posted on by Lym

In SharePoint online, I have a “Purchase Order” list and it has “Foreign PO” yes/no column.

In PowerApps, I have a combo box that currently display all Purchase Orders. Now I want to display only the Purchase Orders where Foreign PO = Yes.

I have tried updating the “Item” property to the below but it says invalid argument type.

I also tried changing it to below but it displays the item where purchase order is false. Also tried changing it to ‘Foreign PO’ = false but the result is the same.

My combo box

It’s displaying the record where Foreign PO = No. It should display the other record and not display this record.

Any help is appreciated. Thanks in advance.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

SimonPiquer 255 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I believe there is a known bug for Yes/No fields, see: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/158375

As stated in that thread, you can exchange true/false in your filter for 1/0, so your filter could be:

Filter('Purchase Orders', 'Foreign PO' = 1)

The linked thread is quite long and there seem to be a bunch of different issues, I suggest you read through it if you need further assistance!
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lym ,

Do you want to filter based on yesorno field of sharepoint list?
Firstly, let me analyze your first formula.

Filter('Purchase Orders', 'Purchase Orders'.'Foreign PO' = true)

"'Purchase Orders'.'Foreign PO' " represents a table. You can not compare a value with a table.

You should compare a value with a field.

So you should use formula like this to filter based on 'Foreign PO' field.

Filter('Purchase Orders', 'Foreign PO' = value)

Secondly, let us analyze your second formula.

I agree with @SimonPiquer .

Yes, it is an already know issue about yesorfield: You could not compare it with true or false.

For now, it's not supported to compare it with 1/0.

1 represent yes in yesorno field.

0 represent no in yesorno field.

So in your issue, you should use this formula to get the items that 'Foreign PO' value is yes:

Filter('Purchase Orders', 'Foreign PO' = 1)

Best regards,
Lym on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SimonPiquer @v-yutliu-msft thank you both for the response. Yes it worked when I changed it from true/false to 1/0.

Additional question, why is the combo box search functionality not working when filter is added to items?
My combo box setMultiple is set to false but I would like for the user to be able to use the search functionality also. When I tried to enabled it, nothing is displayed.

When isSearchable is false:

When its true:

Thanks in advance.
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lym ,

Please check whether you choose right primary text for this combo box.

What's more, combo box will not reset automatically every time you make any change on it.

So I suggest you delete the original combo box, reinsert one and set it.

Best regards,