Answered

Search statement syntax for filtering using partial string

(1) Share

Report

Posted on by CP-23071818-0

107

How can I change this statement in the Items property of my Records gallery to filter using a partial string? I am using an SP list with over 2000 records so I would need method that supports delegation to SP.

If(SearchInput1.Text="",Table_Dies_1,Filter(Table_Dies_1,product=SearchInput1.Text))
 
this statement works but the user has to key in the exact spelling of the product to get a result. 
 
for example if text value of product in records is '123 widget 1' right now they have to type the whole 123 widget 1 string to get
a filtered result
 
I would like to simply type '123' and get all similar results.  The convention of all our products is basically "### Words" 
 
it would be a bonus if they could key into searchinput1 field either the "###" or "words" part of the string and filter all records 
have the matching string portions.
 
I did find this post below, but i was hoping there was a less Fx code intensive solution maybe? 
No Delegation Limit - SharePoint List Power App (powerplatform.com)

Categories:

General Questions

All responses (2)

Answers (1)

CP-23071818-0 107 on at

Like (0)

Report

Search statement syntax for filtering using partial string

Works like a charm thank you! I also tried to add || Endswith but that apparently does not support delagation but this will be better then scrolling the entire list.
Verified answer

WarrenBelz 146,645 Most Valuable Professional on at

Like (0)

Report
Search statement syntax for filtering using partial string

Hi CP-23071818-0

The best you are going to do with Delegation support directly in Power Apps would be (so 123 would work)
Filter( Table_Dies_1, Len(SearchInput1.Text) = 0 || StartsWith( product, SearchInput1.Text ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee