cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

 

 

 

Thx! 

Status: New
Comments
Level: Powered On

Alternative solution: convert the sharepoint filed to int()

Super User

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.