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
Frequent Visitor

Alternative solution: convert the sharepoint filed to int()

Resident Rockstar

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.

 

 

Regular Visitor

@martinav I had to go three pages deep in Google to find your post...  You are the ONLY one to have sorted this out from what I can see.   Even official MS responses say "not supported".

 

THANK YOU!!

Resident Rockstar

@DaveHepler ,

 

I think I got lucky on this one.  Trial and error with a trace amount of experience pays off every now and then.  Glad you got yours working.