Delegation Warning

[stefano_mazzi]

Hello,

I have this formula with delegation warning:

Filter('Activity List', (Email = User().Email), (StartsWith(Project.Value, TextSearchBox1.Text)))

How I can avoid this warning?

Thank you.

[iAm_ManCat]

Hi @stefano_mazzi

You are accessing a sub-property of the Project field, which the system will not be able to delegate. I would suggest creating a new text column in your datasource that is automatically filled with the text value of Project.Value - that way when you filter the StartsWith will not have a delegation issue

[stefano_mazzi]

Hi @iAm_ManCat 

thank you for your reply 🙂

I created a new calculated coloumn in my sharepoint list called "Project Selected" and update my fx in this way:

Filter('Activity List', (Email = User().Email), (StartsWith('Project Selected', TextSearchBox1.Text)))

But delegation warning is always present.

[iAm_ManCat · Accepted solution]

Calculated columns are not delegable to my knowledge, although they are listed as theoretically working for complex columns where the sub-property is a delegable type, my experience has found this to not always be the case, this is why I suggested a plaintext column that is filled automatically by your App whenever a project is chosen (is what I meant before).

SharePoint - Connectors | Microsoft Docs

[stefano_mazzi]

Thank you @iAm_ManCat .

The solution works great.

[iAm_ManCat]

Excellent, glad I could help @stefano_mazzi, have a great day!

[stefano_mazzi]

Have a great day!