Need help with a delegation issue

[wstock]

I have the following formula on a gallery to try and filter the gallery based on user input into a text field, and I am getting delegation warnings.  

Filter('Client List',StartsWith(searchInput.Text, DisplayName))

"Client List" is a SharePoint List.

DisplayName is a calculated column in SharePoint of "LastName" and "FirstName"  ie:  "Smith, John"

I also get the following "ToolTips" that seems to indicate the issue, I just can't sort out what it means: 

When hovering over the "DisplayName" in the formula bar: 

"The 'StartsWith' function cannot be delegated if a field name appears in the second argument. "

[eka24]

Try:

Filter('Client List',StartsWith( DisplayName,searchInput.Text))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[KrishnaV · Accepted solution]

Hi @wstock 

Unfortunately, Calculated column in PowerApps is not a deligated column see the below article explains what are deligated columns.
https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvement

Also, below is an excellent video playlist created by a reputed PowerApps MVP @RezaDorrani about deligation and best practices:
https://www.youtube.com/watch?v=gwiErbYtRdA&list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[usertestingtest]

Try doing XYZ

[KrishnaV · Accepted solution]

Hi @wstock ,

The best solution for this issue is, add a Flow to that list and populate the calculated value through to a single line of test and implement the filter. Flow can be created for all the operations on the list like add/update/delete.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[wstock]

Thanks @KrishnaV 

Actually, I just figured this out myself just after I posted the question...came back here to mention that exact thing.  Changed to a non-calculated column, and it's all good.  (and ya, as was mentioned in another post, I had my parameters backwards as well...it's been a long morning so far. 

[msaenzpe]

Hi @KrishnaV  I am facing the same issue but the fields I am using for the Filter and StartsWith are Single line of texts... any idea what the issue can be?