filter a Gallery with a few of Keywords in a Textbox

(0) Share

Report

Posted on by Ch3

Hello I would like to filter a gallery using a text box. But I would like to enter more than one keyword as a filter. As a result, only the entries should remain above where each keyword occurs.

As an an example:

This is my Gallery:

No1: Bla Bla Bla

No2: Blu Bla Blu

No3: Blo Bla Blu

No4: Bli Blu Blo

in the Textbox I enter: "bla blu"

Result should be: No2 and No3

in Textbox enter: Blo Bli Blu

Result should be: No4

For two words my Code works but I had no idea how it works for more words.

This is my Code:

Filter(
Galery;
First(
Split(
TextSearchBox1_1.Text;
" "
)
).Result in 'Details:';
Last(
Split(
TextSearchBox1_1.Text;
" "
)
).Result in 'Details:'
)

Categories:

Building Power Apps

All responses (1)

Answers (0)

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Ch3
The functionality you are asking for does not exist in Power Apps. You cannot search for a text string and find record that is ordered differently. The words must be in the same order.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."