Making a search where text contains characters rather than exact phrase

[jamesp24]

Hi

Apologies I am new to power apps and have used the wizard to create an app from a sharepoint list.

It has created the following:

I have noticed that if I start typing in the search box it will only return results in the phrase is exact. So in the example above if I start typing 'test' it shows both whereas if I was to type 'est' or '1' nothing is shown. Is it possible to amend so its if the text is contained rather than an exact phrase? If so can you please give me an idiots guide as to where I go to change this?

Many thanks

[eka24]

You have to use the Search Function. Watch this tutoriai from Shane Young:

https://youtu.be/FaTnOOc34os?t=4

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[gabibalaban · Accepted solution]

Hi @jamesp24 ,

Actually,  this is a sharepoint conector limitations. Its supports searching using StartWith() function, for Search() function the app will give you a warning called delegation warning (that means that the results might not be quite accurate for large data - over 500 items).  

So,  if your list does not have more that 500 items, then:

1.Select the Gallery

2. Go to Items property 

3. Change the formula to something similar to:

SortByColumns(Search([@LookUpTestList],TextSearchBox1.Text,"Title"), "Title", If(SortDescending1, Descending, Ascending))

, where [@LookUpTestList] is your sharepoint list, "Title" is your searchable column

Hope it helps !

[jamesp24]

Thank you works perfectly