Filter a query by Yes/No column not working.


I am sharing my experience with you,

Issue: Today what I found weird issue with power automate that I cant able to filter data using yes/no column of SharePoint.

Solution: what I found as solution that if you have added “yes/no” column when you have already some records in the list  the old record will not be filtered as per your expectation, so for old records you need to manually update yes no column for each record of write some automate to update it.

the condition would be like as below