Instead of StartsWith, what about Contains

[Anonymous]

I am modifying an out of the box search field which then filters the gallery. The data is imported by an SPO data connection (list).

In the gallery I have:

SortByColumns(Filter(ControlRoomContacts, StartsWith(Title, TextSearchBox1.Text)), "COMPANY", If(SortDescending1, Descending, Ascending))

So the StartsWith function then looks within the Title field but it only looks for a search that starts with. For example:

If someone searches for  Library, it will only find something in the Title field that STARTS WITH library. What if I want it to search in the title field for something like Cafe Library instead?

[Meneghino · Accepted solution]

Hi @Anonymous, you can use the in operator

This operator is not yet delegated for SP lists so you will only query the first 500 records

[Anonymous]

That's great thanks.

[Anonymous]

Hi - I would very much appreciate an example of this solution, where the suggestion is to replace "StartsWith" with the "in" Operator. In my example:

SortByColumns(Filter('DataSource', StartsWith(FieldName000, TextSearchBox1.Text)), "FieldName000", If(SortDescending1, Descending, Ascending))

How would I correctly replace "StartsWith" with the "in" Operator, so that using this expression searches the whole of FieldName000 for any input entered in TextSearchBox1.Text - instead of it only checking the Start of the Field for a match?

Thanks!

[rabiawilliams]

Hey there check this sample code to replace StartsWith with in

ClearCollect(Contacts, SortByColumns(Filter(Office365.ContactGetItems(DropdownContact.Selected.Value).value, TextInputSearchContact.Text in DisplayName), "DisplayName"))

Cheers,

[Anonymous]

Thanks - I will give it a try!

[SoorajDathan]

Try search instead of filter

SortByColumns(Search(ControlRoomContacts,  TextSearchBox1.Text, Title)), "COMPANY", If(SortDescending1, Descending, Ascending))

[Anonymous]

Hi,

 I am looking for a little help.  I have a gallery and it is working as it is meant to, however, i kinda need it not to work as it should.  What i need is for it not to show all the list from the search (filter)  What i need is to enter the employee number at the search and not to show everyone when the box  is empty.  i need it to only show the person who's number is typed in after it is typed in.  This is the code i have on the Items:

Filter(Employees, StartsWith(Cal, TextSearchBox1_1.Text))

Any help would be great.

[sharathgn]

Hi you can simply use default text function in search bar. Insert default text "Enter employee ID" so that it won't display any result.

• There might be many other ways but this is the easiest one I feel.

[CullumGiles]

The below works for me in a Wiki App which I developed where Wiki List is the SharePoint list name and Title is the field to be searched.

Within the Browse Screen, Select Browse Gallery and in formula bar Items = Search('Wiki List', TextSearchBox1.Text, "Title")

You may be prompted with a delegation warning regarding limitations on use of search with (SharePoint) datasets exceeding a 500 record limit, so this is currently only a viable solution with smaller datasets.