AddColumns is raising delegation warning although i am filtering based on ID numeric field

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have this formula:

Clear(colWOSPD);
ForAll(
 colWOSP As wosp,
 Collect(
 colWOSPD,
 Filter(
 'Work Orders Spare Part Details',
 'Work Order Spare Part ID' = wosp.ID And SparePartApprovalStatusSync="Approved"
 )
 )
);

Sum(AddColumns(colWOSPD As cd, "PriceHidden", If(IsBlank(LookUp('Spare Parts',ID=LookUp('Work Orders Spare Parts',ID=cd.'Work Order Spare Part ID').'Spare Part ID').Price),0,LookUp('Spare Parts',ID=LookUp('Work Orders Spare Parts',ID=cd.'Work Order Spare Part ID').'Spare Part ID').Price)), PriceHidden);

but the AddColumns() is raising this delegation warning, although i am filtering based on ID numberic field:

any advice , how to solve the delegation ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@johnjohnPter ,

The Delegation warning is actually the relational Lookup

LookUp( 'Spare Parts', ID = LookUp( 'Work Orders Spare Parts', ID = cd.'Work Order Spare Part ID' ).'Spare Part ID' ).Price

SharePoint is not a Relational Database and does not support this functionality. How big are the lists 'Spare Parts' and 'Work Orders Spare Parts' ?

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@WarrenBelz spare parts can have more than 2000 items. work orders can grow much more , we have around 100 work orders added each working day.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@johnjohnPter ,

You cannot use your current structure in a Delegable manner if neither list is under your limit. The below is my best effort (I cannot test it) on an alternative structure.

With( { _Data1: Ungroup( ForAll( colWOSPD As _cd, Filter( 'Work Orders Spare Parts', ID = _cd.'Work Order Spare Part ID' ) ), "Value" ) }, With( { _Data2: Ungroup( ForAll( _Data1 As _Part, Filter( 'Spare Parts', ID = _Part.'Spare Part ID' ) ), "Value" ) }, Sum( _Data2, Price ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No