Hi Folks,
I'm trying to filter a collection and populate the result in a gallery. I have multiple filter conditions combined using an "OR" operator. For certain keywords it seems most relevant results are showing up on bottom rather than on top. In situations where multiple filter conditions are true, in which order do the results return and can we manipulate it somehow?
Example of my filter conditions:
Distinct(Filter(First(colSkills).value,Lower(First((Split(TextInput2_1.Text," "))).Result) in Lower(Title) ||
Lower(Left(TextInput2_1.Text,2)) in Lower(Left(Title,2)) ||
Lower(First( Split( Last( Split( TextInput2_1.Text,"/" ) ).Result, " " ) ).Result) in Lower(Title) ||
Lower(Last( Split( First( Split( TextInput2_1.Text,"/" ) ).Result, " " ) ).Result) in Lower(Title) ||
Lower(Trim(TextInput2_1.Text)) in Lower(Title)
,Title).Title, Title)
TextInput2 is the search bar. Please don't get confused by the usage of First(Col) as in my case the whole table is in the first index of collection.
Kindly share your thoughts on filter query output order.
