Announcements
I have a field that shows me a warning with this formula can you enlighten me?
What kind of datasource do you use? Dataverse, SharePoint, SQL Server ...?
This link to the docs might help as well: Understand delegation in a canvas app - Power Apps | Microsoft Learn
datasource is SharePoint
Is PROJECT_CODE of data type text?
Where do you perform this formula on an OnSelect and on which control?
no; on onChange control
What is de data type of PROJECT_CODE?
Can you maybe give some more context about the SharePoint lists used in the example?
Thank you
the code_project is a calculate field on the sharepoint, but on the other sharepoint lists it is a lookup field
Hi @Anonymous
It looks like that calculated field is causing the delegation warning.
A quick fix might be to add a new column which is just a text version of your calculated column:
ClearCollect(tr_table, Filter(AddColumns('CL PROJECT',"PROJECT_CODE_TEXT", PROJECT_CODE), PROJECT_CODE_TEXT = DataCardValue120.Selected.Value))
It might not be the cleanest solution, but it does the trick.
Kind regards,
Feline
@Feline Thank you this way works but, After reading some article, the Delegation problem is quite common if especially if I start to exceed the limit of 5000 records, so I have to go through power automaton to solve it completely.
Hi @Anonymous What is the PROJECT CODE field type? as I see you're using a combo box it looks a choice field, then you're missing a dot like 'PROJECT CODE'.Value try that
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 387
timl 340 Super User 2026 Season 1
Vish WR 301
