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

How to search by any keyword

Hello,

 

was wondering how to search by any Keyword written. For example if i have "BVC123" and I type 123, i would like it to show up. Right now I have to write "BVC" anyway to fix this?

 

This is what I have one gallery : 

 

SortByColumns(
Filter('GSE WHOLE LIST',
StartsWith(Title,TextSearchBox5.Text)),
"Title",
If(SortDescending1, Descending, Ascending))

 

and the second one is: 

 

Filter(EMPLIST,
Or(StartsWith(Title,TextSearchBox12_2.Text),
StartsWith(EMPNAME,TextSearchBox12_2.Text)))

 

Just want to be able to write any text to pull up . I don't like I have to always right the beginning letters of what Im looking for . 

Thank you! 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Sahara22,

Do you want to filter gallery based on the key words?

Could you please share a bit more about the scenario?

Actually, the StartsWith() function do support the start string in a word rather than anywhere in a word. If you want to search by any character contained in a word, you should use the Search() function.

However, the Search() function could only support the Text columns, you could only refer to a single-line-text type like Title.

Modify your formula as below:

SortByColumns(
Filter('GSE WHOLE LIST',
TextSearchBox5.Text in Title),
If(SortDescending1, Descending, Ascending))

Or if you want to use the Search() function, you could try as below:

Search('GSE WHOLE LIST', TextSearchBox5.Text, "Title")

Best Regards,
Qi

View solution in original post

3 REPLIES 3
Sakura
Helper II
Helper II

Have you looked at Search?
You can look for any substring in one or more columns this way.

v-qiaqi-msft
Community Support
Community Support

Hi @Sahara22,

Do you want to filter gallery based on the key words?

Could you please share a bit more about the scenario?

Actually, the StartsWith() function do support the start string in a word rather than anywhere in a word. If you want to search by any character contained in a word, you should use the Search() function.

However, the Search() function could only support the Text columns, you could only refer to a single-line-text type like Title.

Modify your formula as below:

SortByColumns(
Filter('GSE WHOLE LIST',
TextSearchBox5.Text in Title),
If(SortDescending1, Descending, Ascending))

Or if you want to use the Search() function, you could try as below:

Search('GSE WHOLE LIST', TextSearchBox5.Text, "Title")

Best Regards,
Qi

View solution in original post

Sahara22
Helper V
Helper V

Thank you, it worked!!! 🙂 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,021)