You’re offline. This is a read only version of the page.
43
Good afternoon,
I need to make a filter of people, but I am dealing with a problem.
If I input "Max" and "Josh" on the filter, when I use the filter searching in other order, like "Josh" and "Max", the filter don't recognize the names.
See below the images for better understanding.
The order of the names inputed, changes the filter result.
If you want to have more informations, please feel free to ask.
Doing some tests here, I noticed that the filter is actually working now, but for some reason the values of the "ThisItem" formula are not bringing the information they are supposed to.
They are just bringing empty values for all the rows.
As you can see here, there are 2 rows that are coming with the filters, that's exactly the quantity that I expected.
I'm not sure why the values are not showing up, but the filter formula is working now.
Ignore the errors on the picture, there is a pop up there.
Do you have any idea of how can I get the values back on the gallery?
Please see small correction in third line.
Good morning,
Thanks for helping me on this issue @WarrenBelz and @KeithAtherton !
Answering to Keith's question, if I use the formula that he said, the filter does not work, I've already tried it.
About Warren's formula, I tried it but i got some errors.
Find attached the message I received when I try the formula.
HI @csouza123 ,
Adding to to @KeithAtherton 's comments if you are trying to do a many-to-many filter here, you need to approach this differently as per the example below as "one side" of the comparison needs to be a single value querying a Table on the other.
Share
Report
All responses (
Answers (
With(
{
_Data,
Ungroup(
ForAll(
ComboBox1_1.SelectedItems As _Item1,
Filter(
solucoes_tech_mainbase,
(
TextInput1_2.Text in 'Nome da Solução' ||
TextInput1_2.Text in Descrição
) &&
_Item1.DisplayName in NomeCriador.DisplayName
)
),
Value
)
},
Ungroup(
ForAll(
ComboBox2_1.SelectedItems As _Item2,
Filter(
_Data,
_Item2.Value in 'Tecnologias envolvidas'.Value
)
),
Value
)
)
Hi @csouza123,
The issue may be that the following code concatenates all ComboBox1_1.SelectedItems into a single string, e.g. "Max,Josh,":
Concat(ComboBox1_1.SelectedItems, DisplayName & ",")
This means that when we compare it with another string, that exact string (e.g. "Max,Josh,") must match in the other string.
However, what happens if you change that code to the following to compare NomeCriador with all items in ComboBox1_1.SelectedItems?:
NomeCriador in ComboBox1_1.SelectedItemsIf I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
