cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Show only if search is exact match

Hello,

 

how can I make the gallary show results only if the search value matches 100%?

 

The code that i got so far is:

 

If(
!IsBlank(
TextSearchBox1_1.Text
);
Search(
BezoekersRegistratie;
TextSearchBox1_1.Text;
"Title"; "Bedrijfsnaam")
)

 

The result now is that the gallary wil show items even if i only type the first letter. for exmple an a. but is needs to show only if the title matches 100%. so for exmple the value is test 123. ik only want to view the item in the gallary if test 123 is enter.

 

hopefully someone nows the answer

 

thx in advanced

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi @icturion ,

If you want an exact match, you do not need Search - I am assuming you want either of these columns to equal the text in your search box?

If(
   !IsBlank(
      TextSearchBox1_1.Text
    );
    Filter(
      BezoekersRegistratie;
      Title=TextSearchBox1_1.Text Or
      Bedrijfsnaam=TextSearchBox1_1.Text
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

2 REPLIES 2
Super User III
Super User III

Hi @icturion ,

If you want an exact match, you do not need Search - I am assuming you want either of these columns to equal the text in your search box?

If(
   !IsBlank(
      TextSearchBox1_1.Text
    );
    Filter(
      BezoekersRegistratie;
      Title=TextSearchBox1_1.Text Or
      Bedrijfsnaam=TextSearchBox1_1.Text
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

thx works perfect

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (10,014)