Answered

Need help with a delegation issue

(0) Share

Report

Posted on by 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. "

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

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 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Try doing XYZ
Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

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 57 on at

Like
a
(0)

Report
Copy link

Link copied!

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 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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?