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
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"))
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
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!