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
Solved! Go to Solution.
**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/
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.