Filter Query for boolean value in Excel "List rows present in a table"

[fraenK]

Hi, 

1. Excel file with a column "active" containing boolean values =TRUE() / =FALSE()
2.  Excel "List rows present in a table" action with a Filter Query:

active eq 'True'

The Excel connector without a Filter Query returns a string value for this column:

"active":"True"

but using the Filter Query it returns nothing.

I also tried to compare it to bool('true'), string('True'), true, 1, contains(active, 'True'), startswith(active, 'True'), nothing worked.

Is this a bug / limitation or strange feature?

[mahoneypat]

I tried your syntax out on my end and it worked as expected.  Not sure what is going on.

Pat

[fraenK · Accepted solution]

Thanks for checking! You won't believe the reason why it wasn't working for me!

It is language specific!

My Excel file shows the boolean value in German language and the Filter Query only works for the German value even if the connector itself returns a JSON value in English!