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.
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.
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)?
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)
User | Count |
---|---|
250 | |
248 | |
82 | |
45 | |
30 |
User | Count |
---|---|
340 | |
261 | |
123 | |
64 | |
58 |