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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
195 | |
45 | |
45 | |
39 | |
35 |
User | Count |
---|---|
269 | |
83 | |
81 | |
73 | |
70 |