Combine toggle button with a filter function

[WackdeMack]

Goodmorning all,

I have a PowerApp with a few fields. I want to use two toggle button to filter a yes/no column and a choice columns.

My filter works fine separately but i can't combine it. How can i use together?

I use this code for the items @ the gallery but after this i won't see all the items. I think first i need to load all the items and with the OnChange from the Toggle use this filter below?

Filter(TestPowerApps, If(Toggle2.Value = true, Status.Value="Error")) 
Filter(TestPowerApps, If(Toggle1.Value = true, Paid =true)

Column paid = yes/no

Column status = choice column

[PowerAddict · Accepted solution]

Say toggle1 sets variable1 to true (or false) and toggle2 sets variable2 to true (or false).

Now set the items property of your gallery to:

Filter(TestPowerApps, !Toggle2.Value = true || Status.Value="Error", !Toggle1.Value = true || Paid =true)

Let me know if this works.


---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[WackdeMack]

**bleep**, i was so close 🙂 I only changed the last item to 

Filter(TestPowerApps, !Toggle2.Value = true || Status.Value="Error", !Toggle1.Value = true || Paid =1)

Paid=1 because true or false doenst work very well with yes/no column. I found this blog about this issue https://rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/

@PowerAddict Thanks! 
 

[PowerAddict]

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com