cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Soko19
Level: Powered On

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.

Soko19
Level: Powered On

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.
Soko19
Level: Powered On

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?

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)?

Soko19
Level: Powered On

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.
NigelP
Level 8

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

Soko19
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,517)