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?
Solved! Go to 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).
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).
@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
User | Count |
---|---|
254 | |
246 | |
82 | |
44 | |
27 |
User | Count |
---|---|
341 | |
267 | |
123 | |
61 | |
58 |