
Hi Experts,
I am trying to collects all CostID's Related to all Payments (N:N Dataverse Relation) in a collection. I am trying formula below But this gives Delegation warnings. How would I get the same result and make it delegable?
ForAll(
colPayments As C,
ForAll(
C.'Costs' As D,
Collect(
colCosts,
{CostID: D.'Cost'}
)
)
)Best Regards,
Anthony
@Anthony_Dob You would be getting the following warning,
This is not a delegation warning. This is just to warn that this may incur lots of calls to the datasource.
Please remember to give a 👍 and accept my solution as it will help others in the future.