Hi
I have a table that Im wanting to be filtered by certain peoples names, so that all records with these names are filtered into a separate collection.
The peoples names/initials are retrieved from a separate filtered collection transferred into a string using concat, and manipulating the separators etc to put them into a filter formula. "AMC","LME","NFI"
Im struggling to find the base formula that will allow multiple names be filtered from one column to create the new collection or im not working in the And/Or Functions Correctly
For example
Collect(colcrewstatall, Filter(colcrewdataall, Operator = "ConcatValue1", Operator = "ConcatValue2", Operator = "ConcatValue3", Operator = "ConcatValue4"))
or the filtering formula values are pulled as text from a label control etc (concat data)
Powerapps accepts the formula but nothing happens or puts all records in collection without filtering first.
Collect(colcrewstatall, Filter(colcrewdataall, Operator = "ConcatValue1" || Operator = "ConcatValue2" || Operator = "ConcatValue3" || Operator = "ConcatValue4"))
try that
though don't forget to clear your collection between presses since that is only doing the collect instead of ClearCollect
I was clearing the collect before each use, Thanks! that base formula works but not when filtering with the concat values. Im going to try again and see how it goes
User | Count |
---|---|
254 | |
106 | |
95 | |
50 | |
39 |