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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
203 | |
98 | |
60 | |
56 | |
52 |
User | Count |
---|---|
257 | |
161 | |
87 | |
79 | |
68 |