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/
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT