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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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