What to use instead of StartsWith to search entire box

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I have this -

StartsWith(Control_two.Value, 'search box'.Text) || StartsWith(ID_three, 'search box'.Text)

but this only searches for the first part of the string. How can I do a full Contains here?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
You can use the search function.

Search(sharepointlist,"text to search for","field to search in")

Note the field name does go in quotes.

The problem with this is that this is not delegable, so this will have issues with larger lists.

Another way is to use in:

Filter(sharepointlist,"text to search for" in fieldname)

But again, also not delegable.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Mike2500 thanks, how can I use it with my current setup? I have a search box i want to be able to use to search for both my fields.

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Search supports multiple columns:

Search(sharepointlist,"text to search for","field1","field2")

or, for using it with the search box:
Search(sharepointlist,txtSearch.Text,"field1","field2")

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Mike2500 getting error -

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report

What is control two? After "search box.text", the next item should be the name of the field, in quotes, that you want to search. Optionally, after that, you can put the name of a second field you want to search.

The delegation warning is expected. This will not work with larger datasets.

Was this reply helpful? Yes No
Chris-D 1,246 on at

Like (0)

Report

What are you finding text in? Your code looks like a boolean statement, are you using this on a control, or to search a data source?

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Chris-D @Mike2500 Control_two is a sharepoint list column. It is a choice column to be specific.

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report

What data type is control_two?

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Mike2500 its a choice column. Is there another way to check?

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report

Search is used to find text within a large block of text. If it's a choice, do you really need to search within the choice value?

For example, if the choices are north, south, east, and west. Do you need to let the user find all choices with the letter "e"? Or are you looking for all list items that have west? I assume the latter? If so, use filter instead of search:

Filter(sharepointlist,control_two.Value="West")

Was this reply helpful? Yes No