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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report

Both Availabile and Availability are Yes/No columns in SharePoint?

Was this reply helpful? Yes No
ck25415 294 on at

Like (0)

Report

Hello @Jeff_Thorpe ,

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

Correction: column names are Available and Availability

Thanks,

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ck25415 294 on at

Like (0)

Report

Thanks @Jeff_Thorpe .

Was this reply helpful? Yes No