Unanswered

multiple search words search in a gallery

(0) Share

Report

Posted on by Kurry

I have a textbox (TextInputFilterEvents) that I want to populate with search words:

"tra provinciale voorronde 1"
with the onchange event of the textbox, I populate a collection with these separate words:

ClearCollect(
ColSearchWords,
Split(TextInputFilterEvents.Text, " ")
);

ClearCollect(
ColFilteredClubInfo,
ForAll(
ColSearchWords As SEARCHWORD,
Filter(
VarEvents,
SEARCHWORD.Value in title
)
))

Then I have a gallery (VarEvents) that contains the field title, and I want to filter that gallery on the filter that contains all the keywords from the textbox. The words can be in a random order in the "title" field.

Filter(
VarEvents,
Sum(
ForAll(
Filter(Split(TextInputFilterEvents.Text, " "), Len(Trim(Result)) > 0),
If(Result in title, 1, 0)),
Value) > 0);

This code does not work, it returns results that contain only 1 of the words, I want all words to be in the title field.

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @Kurry ,
To ensure that all words from the TextInputFilterEvents text box must be present in the title field of your VarEvents gallery, you can adjust your PowerApps code. The goal is to create a filter that checks for the presence of each word from the search text in the title field and ensures that all of them are found.
Splitting the Search Text into Words
This step is correct in your approach:

ClearCollect( ColSearchWords, Split(TextInputFilterEvents.Text, " ") );

Filtering the Gallery
To filter the VarEvents such that all search words must be in the title, you can use a combination of ForAll and And to ensure that each word is present.
Here’s the modified code for the filter:

ClearCollect( ColFilteredClubInfo, Filter( VarEvents, And( ForAll( ColSearchWords As SEARCHWORD, SEARCHWORD.Value in title ) ) ) );

Was this reply helpful? Yes No
Kurry 69 on at

Like
a
(0)

Report
Copy link

Link copied!
Your code looks good, but I think he does not like the array in the loop.
Invalid argument type (Table). Expecting a Boolean value instead.

Thx for helping me out!

Was this reply helpful? Yes No