Filter on SharePoint YesNo Field

(0) Share

Report

Posted on by iwonder

1,146

Thank you for taking the time to read my question.

I have a connection to a SharePoint List that has a Yes No field called IsActive.

My Gallery Items equals DataSource

When I try to use Filter() on DataSource to filter all IsActive = true I get no results. I found one post saying that it was a known bug in 2018... but its 2021.

Filter(DataSource,IsActive-true) returns nothing

When I don't filter, my Gallery shows IsActive as being true for all the correct records.

Is this fixed or do I have to make my own field and use zeros and ones?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Of course I found the answer AFTER I posted the question.

Reza Dorrani has a video where he suggests using a Choice list in SharePoint due to the bug.

Power Apps Gallery Multiple Filter - Choice, Lookup and Yes/No column - SharePoint & delegation - YouTube

Thanks for the video!!

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@iwonder

Also, take the extra true out of your formula:

Filter(DataSource,IsActive)

That should return all the true recrods.

Was this reply helpful? Yes No
iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes

I changed my SharePoint field back to Yes No and then used your Filter formula and it worked great!

Was this reply helpful? Yes No