cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
moutinhoabreu
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
v-yamao-msft
Community Support
Community Support

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.

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,698)