Hi
So I have read a couple of posts around Multiple Filtering with the List but could not get the exact idea as the solutions were a bit specific to their needs.
I have my own scenario and here I would like to explain. I have got a custom collection;
FilterList,
{
FilterName: "Scheduled",
IsFiltered: false
},
{
FilterName: "Started / In Progress",
IsFiltered: true
},
{
FilterName: "Finished / Completed",
IsFiltered: false
},
{
FilterName: "Due",
IsFiltered: true
}
I have got a Gallery that is bound to another collection which have got a same Statuses as FilterNames ("Scheduled, "Due" etc.)
My question is, what's the best way to filter my items in the Gallery based upon the filter's IsFiltered property to true? I can have 2, 3, 4 or even 1 filter setup at any point of time and my list should be able to be filtered by that.
The way I was trying was:
Filter(MyCollection, // collection
If(CountIf(Filters, IsFiltered) > 0, // condition
CountIf(Filters, FilterName in "In Progress") > 0, // nested condition
('Status' in "In Progress"), // if condition is true
CountIf(Filters, FilterName in "Scheduled") > 0,
('Status' in "Scheduled"), // if condition is true
true))
Do you think there is a better way of achieving the objective (stated above)? Or am I doing it perfectly well. 😛
Looking forward to learn from the experts.
