Hello,
No idea what we are doing wrong
But i like to add groupby on field_7
With the function Search because it shows me everything we use in a search criteria
Not with startswith i don't get all my results.
So i used before without groupby
And that works well, except i get duplicated field_7 names
Search(
Filter(
[@colMyList2];field_3
)
;
SearchInput_1.Text;
"field_7";
"Title";
"field_1";
"Lastname";
"Firstname"
)
So to prevent that i want to try it with groupby
But seems it won't show me everything from my search criteria
Only when you write it as been stored in the colMyList2
GroupBy(
Search(
Filter(
[@colMyList2]; field_3;
field_7 in SearchInput.Text ||
Firstname in SearchInput.Text ||
Lastname in SearchInput.Text ||
Title in SearchInput.Text ||
field_1 in SearchInput.Text
);
SearchInput_1.Text;
"field_7";
"Title";
"field_1";
"Lastname";
"Firstname"
);
"field_7";
"Data"
)
Any help
Thank you
