Filtering is not getting correct for Datatype BIT in sql server through powerapps

[Chandu]

Filter('[dbo].[TEST_DATA]', TEST_TYPE = varTestType && TASK_ID = Value(DataCardValue52.Text) && ISACTIVE = "1")

I am having a Gallery, where I am filtering Gallery based on above formula.

When I Click PTI Button in top right corner, Then: Test_Type='PTI' , TASK_ID = Getting Value from DisplayForm and ISACTIVE = "1" (Datatype = BIT in SQL). 

When I Click PTI Button in top right corner, Then: Test_Type='PDI' , TASK_ID = Getting Value from DisplayForm and ISACTIVE = "1" (Datatype = BIT in SQL)

Now, my Issue is I am getting Warning Error, and filtering is not happening, when I added ISACTIVE = "1" in Filter() and for PTI Gallery Items ISACTIVE = "1", for PDI Gallery Items ISACTIVE = "0".

According to my formula, when I click PTI it must show Items where ISACTIVE = "1". But, it is showing blank.

[v-monli-msft · Accepted solution]

Hi @Chandu ,

BIT values in SQL have 3 possible values: true, false, null. Please use true, false to Filter the gallery instead.

Regards,

Mona

[ruig · Accepted solution]

Hi @v-monli-msft,

This solution works.

Thanks,

Rui