cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fraenK
Memorable Member
Memorable Member

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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! 

View solution in original post

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

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

mahoneypat_0-1637782089549.png

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI 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! 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,457)