Announcements
I have a need to filter for the name with a string. I am getting the desired data back with the StartsWith...if the string starts with the name selected in the Combo Box.How do I write the formula to say if the matching data is anywhere in the string return the associated data?
StartsWith(Professional1, ReviewScreenSearchComboBox.Selected.Value)
@Phineas
You can use ‘in’ but it’s not delegable, ie
ReviewScreenSearchComboBox.Selected.Value in yourListName.Professional1
You can use Search rather than StartsWith but note that this will not be delegable if you are using SharePoint as your datasource.
And, if my limit is set at 2000, but I never have near that to query/filter it should be good?Edit:Also, here is the same formula with Search rather the StartsWith. Power Apps didn't like it. There was no error with StartsWith.
Error is: "Invalid number of arguments: received 2, expected 3 or more."||Search(PSMCCCategoryCommodity && PSMPPCategoryCommodity,ReviewScreenPSMSearchComboBox.Selected.Value))
Yes, if you set your App's delegation limit to 2000 in settings (default is 500) then you should not have an issue with the Search missing some results assuming your record count does not exceed the delegation limit.
You will suffer slower performance than StartsWith (as Power Apps must load the full dataset and SP is a slow datasource) but it sounds like that is likely an acceptable trade-off in this case.
What about the error?When I use Search Power Apps kicks back and error (see formula provided in last post).
You need to supply at least 3 arguments
1. The list/table to filter
2. The search term
3. The field you want to look within
You can supply additional 'fields to look within' as additional arguments, but you need to supply at least one.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 762
11manish 640
Valantis 548
