Delagation error with &&& in a filter on dataverse when using variable in stead of number.

(0) Share

Report

Posted on by HansHeintz

704

This code (excusez the european)

;;ForAll(
 Sequence(4;NumberOfPasses-3;1)
 
 ;Collect
 (
 CachedLastDierExtra;
 Filter(
 DierExtra
 ;DocaNummer >= (Value * 2000) And DocaNummer < (Value+1) * 2000
 
 )
 )
 )

yields a delegation error if table dierextra is a dataverse table but not if it is a sql table.

If I replace (value*2000) and (value+1)*2000 with hard numbers the delegation troubles disappear.

Putting these values into new variables outside the forall loop does make the delagation go away, but inside, alas, UpdateContext is not allowed by Lord Powerapps 😉

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@HansHeintz

Try:

;;ForAll( Sequence(4;NumberOfPasses-3;1) ;With({minValue:Value * 2000; maxValue:(Value+1) * 2000} ;Collect ( CachedLastDierExtra; Filter( DierExtra ;DocaNummer >= minValue And DocaNummer < maxValue ) ) ) )

to see if the problem persists.

Hope it helps !

Was this reply helpful? Yes No