Get Items in SharePoint List based upon Checkbox

[skylitedave]

Is a SharePoint checkbox (yes/no) a supported field type for Get Items for SharePoint in Flow. I have tried all of the following in the Filter Query Odata Entry in Flow

checkbox eq true

checkbox eq bool(1)

checkbox eq Yes

checkbox eq yes

checkbox eq 1

checkbox eq 'Yes'

checkbox eq 'yes'

None of these work.  All give the same error with multiple retries and a status of "Bad Gateway"  

I CAN get a checkbox to work fine in an if statement with the syntax below if I nest an if under a get items based upon other fields within the list.  So a checkbox is suppported in the If Condition

@equals(item()?['checkbox'], true)   

I even tried puttting true in as a function 

checkbox eq function(true)

No luck

Thx!

[v-yuazh-msft]

Hi @ skylitedave,

Does the "Checkbox" type column is the "Yes/No" type column that you mentioned?

I have made a test and the issue is confirmed on my side, 

Filter Query the "Yes/No" type column is not supported in microsoft flow currently,

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

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

Regards,
Alice Zhang

[skylitedave]

Correct - Tying to get lis items based upon a Yes No Field in SharePoint....

At least I know it is not presently supported....This is needed for many scenarios......

Follow this link to vote for this capability

https://powerusers.microsoft.com/t5/Flow-Ideas/Get-Items-SharePoint-List-Add-support-for-filtering-u...

Thx

[SPA]

Okay, I banged my head on this one for a while too... In SOME cases, Power Automate (FLOW)'s Filter Query does not recognize SharePoint's boolean field values as T/F or Y/N.... it sees them as 1/0 so the following should work:

checkbox eq '1'    (for true values)

checkbox eq '0'    (for false values)

I know this was a very old post, but hopefully this helps someone in the future as searches for solutions rarely return this info

[bdewitt]

I had the same issue, and this worked for me.  Thanks for sharing!

[SteenJakobsen]

THANK YOU  ... saved my day 🙂

also take a look at Fusion (nocodesolution) - it might be helpful in many cases where flow just cannot do it 🙂

[SteenJakobsen]

THANK YOU !!   Your tip saved my day!

also take a look at Fusion (nocodesolution)  .. it is free and it helps where flow cannot do it.

[dennis51]

Thanks so much - this did the trick!!!!