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)
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
172 | |
62 | |
32 | |
31 |
User | Count |
---|---|
338 | |
270 | |
105 | |
71 | |
56 |