Unanswered

Delegation Warning and Using SUM with Filter Lookup in Power Apps

(0) Share

Report

Posted on by AM-24100726-0

"I am facing a delegation warning when trying to use the SUM function on a table that includes a Lookup column in Power Apps. I am working with the 'Construction (dev)' table and filtering based on Project_Capex.Id using the SUM function. I also want to sum values from a column that uses the LookUp function from another table, Status_Construction_Choice, to get the Parameter value based on Status.Id.
Here is the formula I am using:

Sum(
  Filter('Construction (dev)', Project_Capex.Id = ThisItem.ID),
  LookUp(Status_Construction_Choice, ID = Status.Id).Parameter
)

I am getting a delegation warning saying that Project_Capex.Id cannot be delegated when trying to filter the data. I have tried different approaches, but the delegation warning persists. I am unsure how to properly optimize this formula to avoid the delegation issue.
How can I resolve this delegation warning? Is there a better way to use the SUM function on data that includes a LookUp from another table? How can I delegate both the filter and lookup efficiently? Thanks for your help!"

Categories:

Power Apps Pro Dev & ISV

Screenshot 2024-1...

I have the same question (0)

All responses (2)

Answers (0)

Nandit 1,568 Moderator on at

Like (0)

Report
Hi AM-24100726-0

Quick question - where is this table coming from - SharePoint / Dataverse / Others? 'Construction (dev)'

Also I don't think your syntax is correct, Sum expects a Data Source and the column you want to sum the values of:

Sum(Filter('Construction (dev)', Project_Capex = ThisItem.ID, ColumnName)

Would be great if you could explain what part is LookUp playing in your function, I will be happy to assist you.

Kind regards,

Nandit

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit

Was this reply helpful? Yes No