web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering database wit...
Power Apps
Suggested Answer

Filtering database with multiple toggles

(1) ShareShare
ReportReport
Posted on by 2
Hey there, thanks in advanced. 
There is one toggle per each column in my database, my idea to use toggle to filter, below is an example, if Milk toggle (Milk tg) is true I would like to see all items with Milk, then if also Wheat is true, I would like to see items with Milk, Wheat and Milk and Wheat, currently I have no visibility of the one with only Milk when it is true but when both are true does.
 
My idea is to create a seach app with below filters, I will have in total 19 toggles + 3 dropdown list, each value filter one specific column
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,604 Super User 2025 Season 2 on at
    Hi
     
    Just for clarification. If you search for things that EITHER have Milk or Wheat, then you do not need another for Milk And Wheat as they are already included.
     
    You don't need the CheckBox check values. I am not sure what they are for. Let me explain
     
    1. I would expect that you would have a Gallery that is like this
    Items = Filter('LA Product Families', Milk Or Wheat);
     
    Now I didn't say Milk = true, because I am assuming its a Boolean correct? It is fine to put Milk = true Or Wheat = true if you want though
     
    2. The reason I didn't include the CheckBoxes in the Filter because
    • I expect the gallery to be filled with things based on their STORED value, which would just be Milk/Wheat, not the values in the Toggles.
    3.  I would not expect the Gallery to have a Toggle, it would just say True or False (or true / false)
     
    4. I expect that you can add new items, and then when you do, there will be a DropDown/ComboBox/Toggle to select the true/false whether or not
    Milk or Wheat is in the Product
     
    5. I would expect that if someone wants to Edit, they click the row or something (icon maybe on each row), and when it gets into the EDIT FORM
    then again, like #4, you can put in a something that lets them toggle/select it on off
     
    So I would not expect your Gallery to have the toggle etc.
     
     
    Once you re-write it how I haev up top it should work. Yours has flawns and not worth to explain it all, just explain how to fix it and why :-)
     
    Thanks,
     
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 468 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 223 Super User 2025 Season 2

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 206 Super User 2025 Season 2

Last 30 days Overall leaderboard