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

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

Hello,

 

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

Gallary?

 

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 

 

GalleryBrowser:

 

Filters:

 

John Doe

 

Please let me know if you need more info. 

7 REPLIES 7
Super User
Super User

How about something like the following:

 

Filter(

AddColumn(MyDataSource,"HasFalse",If(Q1="No",1)+If(Q2="No",1)+If(Q3="No",1)),HasFalse>0))

 

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.

Hello,

 

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.

Hi

 

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.

 

Regards

 

Nigel

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

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,370)