Patching the current record inside the ForAll function

(0) Share

Report

Posted on by Rieus

143

Hello,

I'm quite stuck. I know there doesn't seem a way to get the current item in a ForAll loop so that we have to resort to LookUp.

I already found this answer.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Current-record-inside-the-ForAll-function/td-p/412988

The problem is that I need the item from the collection I'm looping over. This code doesn't work:

ForAll(colTeams,
 ForAll(TimeSlots,
 If(IsBlank(Tijdslot), Patch(Tijdsloten, Defaults(Tijdsloten), LookUp(TimeSlots, 'Zone ID' = TimeSlots[@'Zone ID'])))
 )
)

It gives me this error:

This code on the other hand works perfectly:

ForAll(colTeams,
 ForAll(TimeSlots,
 If(IsBlank(Tijdslot), Patch(Tijdsloten, Defaults(Tijdsloten), LookUp(TimeSlots, 'Zone ID' = 3)))
 )
)

Please tell me I don't have to rename the column like in this answer:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Reference-Current-Record-of-ForAll/td-p/162054

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Rieus,

When using multiple nested functions that have record scope (Filter, LookUp, AddColumns...), it is advised to use explicit record references for certain loops:

ForAll( colTeams, ForAll( TimeSlots As Inner, If( IsBlank(Inner.Tijdslot), Patch( Tijdsloten, Defaults(Tijdsloten), LookUp( TimeSlots, Inner.'Zone ID' = 'Zone ID' ) ) ) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Rieus 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! And ThisRecord is also an option, that's what I used now 🙂
https://powerapps.microsoft.com/en-us/blog/formulas-thisrecord-as-and-sequence/

Was this reply helpful? Yes No