cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate IV
Advocate IV

Get rows SQL, filter ODATA with a boolean field (Error)

Hi Guys,

 

I'm building a flow using Get rows form SQL action.

The poin here is that i need to narrow down the table by filtering with ODATA filter using a boolean field.

The field name is (inactivo) and i already tried:

inactivo eq 'False'

inactivo eq '0'

 

And the result is always a null output. I know for sure the table has both types of data with 'False' and 'True', so i don't understand if this is a limitation. It seems i can't find anything over the internet.

Screenshot 2018-11-19 at 01.38.39.png

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Get rows SQL, filter ODATA with a boolean field (Error)

Hi @moutinhoabreu,

 

Thanks for feedback.

I am afraid that Boolean column in SQL table has not been supported in Odata filter query in Flow.

If you need this feature, please submit a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate IV
Advocate IV

Re: Get rows SQL, filter ODATA with a boolean field (Error)

Hi 

 

Thanks for you reply.

Indeed i already submited the idea.

Let's see if it colects enough visibility to be considered into a plaaning development.

 

Cheers.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,911)