Get Items SharePoint List - Add support for filtering using Checkbox field type

[skylitedave]

Please add Odata filtering support for Yes/No field types in SharePoint lists using "Get Items". This is presently not suppported.

Thx! 

[wbeedge]

Alternative solution: convert the sharepoint filed to int()

[martinav]

I've been working with this today.  It seems that using the integers 0 and 1 serve as the no/yes respectively.  Try this!

I just did this rather complex statement, and the results appear to be right.

Quality_x0020_Appvl eq 1 and Oper_x0020_Appvl eq 1 and Oper_x0020_Appvl eq 1 and Acct_x0020_Update eq 0 and Modified gt '@{addHours(utcNow(),-48)}'

This statement uses four SP yes/no columns.  It checks their condition and if it was modified in the last 48 hours, and returns that set of items.  It looks to be working perfectly.  No need to change the SP column to integer nor make any enhancement to the system.