Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Help: Show Entries that have a false value in a gallery



I have a powerapp that has multiple Yes(True) or No(False) questions. I have alot of users that have to fill out this created checklist and i want to know when the ckecklist is submitted if there are false responses. 


I dont want to have to go through all the submissions one by one. 


 Is there a way to take all of the submitted checklist and filter out the submissions with a False entry into a seperate



Example: Submitted Checklists 


User = John Doe

Question 1 = No

Question 2 = Yes 

Question 3= Yes 


User = Frank Doe

Question 1 = Yes

Question 2 = Yes 

Question 3= Yes 






John Doe


Please let me know if you need more info. 

Super User
Super User

How about something like the following:





AddColumn gives you a column (HasFalse) which assigns 1 for each "No" and adds together. If there are any "No" answers the value of the column will be greater than 0, so we use a Filter to return just those records.

I will give it a shot and get back to you. Thank you.



I added this to a browser screen under the Items catagory. 


Filter(AddColumn('AO crewleader Checklist',"HasFalse",If('All emails answered? ?_DataCard3'="No",1)+If('RON Audit?_DataCard1'="No",1)+If('Meaningful Lifts?_DataCard1'="No",1)),HasFalse>0))


It doesnot work am i doing something wrong?

What is the error that you are recieving?

Are your 'question' fields text or boolean (true/false)?

They are booleen.

I put the formula in the item field.

When I select the questions to go in the formula should I use the data card name or the datacardvalue # where the toggle button is ?

Thank you.



Whatch out for comparing yes / no s the is a "Feature" where this not always work.  It is safer to use the comparison yesno <> "Yes" rather than yesno = "No" if you are checking if the fiewld value is No.





Hello ,


I created a browser gallery and under the Items catagory i have the belwo formula. The problem is that its not showing anything in the gallary. I know my first question might have been confusing. Please assist


 Filter('AO crewleader Checklist', 'All emails answered? ' = false,'3-HAZMAT Question?'= false,'Am I following up on these emails'= false,'Briefings?'= false,'RON Audit?'= false)

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (53,792)