Answered

Error with combobox filtering boolean column

(0) Share

Report

Posted on by esquiveljc

Hi,
I have my following gallery:

I'm having issues with my combobox filter filtering a boolean column. I created a collection to have text values in my filter:

ClearCollect(ctlValueTest;Table({Choice:"Yes"; Value:true}; {Choice:"No"; Value:false}))

Here is the formula in the Items of my gallery:

Filter(cltTest;
IsEmpty(cbxTxtTest.SelectedItems) || IsBlank(cbxTxtTest.SelectedItems) || txt in cbxTxtTest.SelectedItems;
IsEmpty(cbxValueTest.SelectedItems) || IsBlank(cbxValueTest.SelectedItems) || txt in cbxValueTest.Selected.Choice
)

But when I choose a value in my cbxValueTest filter (yes or no) there is nothing displayed.

Where is my error please?
THANKS

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @esquiveljc ,

The return values of IsEmpty and IsBlank are true and false. We usually use it as a judgment rather than as a filtering condition. For details, you can refer to the documentation: Blank, Coalesce, IsBlank, and IsEmpty functions in Power Apps - Power Platform | Microsoft Learn
Your goal seems to be to not filter the data source when both combo boxes are empty, you can refer to this code:
If(!IsEmpty(cbxTxtTest.SelectedItems)||!IsEmpty(cbxValueTest.SelectedItems),Filter(cltTest,txt in cbxTxtTest.SelectedItems||txt in cbxValueTest.Selected.Choice,cltTest)

Hope this helps you!
-------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li
esquiveljc 4 on at

Like
a
(0)

Report
Copy link

Link copied!

.
esquiveljc 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft,
Thank you for your quick response, but I have an error message in the formula. There is still a data type problem. Excuse me, I'm quite new to PowerApps.

And here are my collections:

Thanks and regards.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @esquiveljc ,

I modified my code, please try this:
If(!IsEmpty(cbxTxtTest.SelectedItems)||!IsEmpty(cbxValueTest.SelectedItems),Filter(cltTest,txt in cbxTxtTest.SelectedItems||txt in cbxValueTest.Selected.Choice),cltTest)

Hope this helps you!
-------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li