cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User
Super User

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

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.

Highlighted
Helper I
Helper I

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

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

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

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?

Highlighted
Super User
Super User

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

What is the error that you are recieving?

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

Highlighted
Helper I
Helper I

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

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.
Highlighted
Kudo Kingpin
Kudo Kingpin

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

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

Helper I
Helper I

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,748)