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

[moutinhoabreu]

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.

[v-yamao-msft]

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

[moutinhoabreu]

Hi v-yamao-msft

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.