Hi,
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?
Solved! Go to 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!
I tried your syntax out on my end and it worked as expected. Not sure what is going on.
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
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!
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |