Gallery filter on SPO column name "Available" and type yes/no always shows false values

(0) Share

Report

Posted on by ck25415

294

Hello,

I have a list with yes/no type column named "Available". If i filter gallery items on this column set to true, the gallery is showing items that have "no" in this column. I dont see this behaviour with the same column type but with a different column name like "Availability". Is this a bug or am I missing something?

Filter(test, Available = true) = does not work, return items with available = no

Filter(test, Availability = true) = Works

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Both Availabile and Availability are Yes/No columns in SharePoint?
ck25415 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Jeff_Thorpe ,

Yes, both are Yes/No type columns in sharepoint.

Correction: column names are Available and Availability

Thanks,
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Apparently this is a bug and there is a planned fix but no ETA. They mention some workarounds like Available=1 but none of them can be delegated to the server. If you list is under 2k items you can increase the data row limit for non-delegable queries in the App Settings > Advance Settings and you should be ok.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/158375
ck25415 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Jeff_Thorpe .