Best-Match Search by Number (not Text)

[ChadBishop]

Relative beginning with PowerApps and I'm wondering if anyone has a solution for searching by number and allowing for best-match results? 

My search box looks at number field within the BrowseGallery.
The formula in the BrowseGallery: 
SortByColumns(Filter([@BetaData],StartsWith(Text(SomeNum),TextSearchBox1.Text)),"SomeNum",If(SortDescending1,Descending,Ascending))

Here is a screen shot of my data

Searching for the matching number BOLD number works as expected. As I type "1001" the gallery begins to filter. 

What I'd like to accomplish is also having the ability to search for a portion of that number (i.e. "1313). 

Is this possible? If so, can you provide details of how you solved it? 

[Drrickryp · Accepted solution]

Hi @ChadBishop 

Try

SortByColumns(
               Filter(
                       [@BetaData],TextSearchBox1.Text in SomeNum
                ),"SomeNum",If(
                                SortDescending1,Descending,Ascending
                             )
)

This will give you a delegation warning so you will need to consider other approaches if your list exceeds the maximum number of items allowed (500 default, 2k max).

[ChadBishop]

@Drrickryp Delegation warning understood. 
Your recommendation appears to have solved my issue. It gives me results for searching "10013" as well as "1313". 

Thank you