cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
skylitedave

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

Submitted by skylitedave on โ€Ž03-30-2018 07:39 AM

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

 

 

 

Thx! 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
wbeedge
wbeedge
Level: Powered On
โ€Ž07-17-2018 03:23 AM

Alternative solution: convert the sharepoint filed to int()

martinav
Super User
Super User
โ€Ž11-15-2019 07:46 AM

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.