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
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/
@PowerAddict Thanks!
User | Count |
---|---|
160 | |
95 | |
77 | |
72 | |
58 |
User | Count |
---|---|
216 | |
166 | |
97 | |
96 | |
74 |