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?
Solved! Go to Solution.
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?
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"))
Try search instead of filter
SortByColumns(Search(ControlRoomContacts, TextSearchBox1.Text, Title)), "COMPANY", If(SortDescending1, Descending, Ascending))
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!