Trouble with Get Items Filter Query on Yes No Checkbox

[gsr51]

I've read several other post dealing with issues filtering on a SharePoint Yes/No checkbox, but I just can't figure it out. The internal name of my field is Create_x0020_JIRA. It is a boolean Yes/No checkbox.  How do I filter to show only those items which are "yes" (true)? 

Thanks all.

[Jcook]

Hello @gsr51 ,

It looks like this feature is not yet supported.

Go here and vote for this feature

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Get-Items-SharePoint-List-Add-support-for-f...

—Josh

If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[gsr51]

I am confused because it seemed that other may have gotten something similar to work. Is there any workaround? What if I changed the Get Items to return all the items and put in a Conditional to check for the "yes" value on the checkbox there?  Is it just not support in the Get Items filter query?

Thanks

[RobElliott]

@gsr51 you need to put the expression inside ' ' apostrophes., for example:

Rob

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[gsr51]

Rob, when I put the expression inside single quotes. I don't get the error when I run it.  However, I'm not getting any expected results back from the query.  Just getting "value": [ ] in the body results.  It's a small test list but there's one item which has the checkbox selected.  Thanks.

[RobElliott]

@gsr51 I wouldn't use an expression there for true/false, just use Create_x0020_JIRA eq 'true'

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[gsr51]

Ok, I changed it to the following.  Still no errors running, but doesn't yield any results. 

[RobElliott]

Have you changed the SharePoint column name at any time?

Also, make sure there is no space after the last apostrophe.

Rob
Los Gallardos

[gsr51]

No, I just created a simple test list for testing this flow.  "Create JIRA" internal name "Create_x0020_JIRA" has always been the name.

Thanks for helping.

[RobElliott]

deleted

[gsr51 · Accepted solution]

I changed it from 'true' to '1' and it works.  I really appreciate your  help today.

[KengSeongLim99]

I changed it from 'false' to '0'  instead of '2' and it works. 

To conclude, when we use Get Items action for Checkbox Data Type with Power Automate, we need to follow concept below: 

Filter Query (true) : CheckBox_ColumnName eq '1'

Filter Query (false😞 CheckBox_ColumnName eq '0'

Really appreciate your help and your post is definitely bring out the concept of handling the Checkbox Data Type in SharePoint List when comes to building automation with Power Automate. 

Thank you so much!