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.
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
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
26 | |
16 | |
16 | |
15 |
User | Count |
---|---|
145 | |
45 | |
44 | |
33 | |
30 |