cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Soko19
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
PaulD1
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
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

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (39,503)