Answered

Increment in a ForAll() with a condition

(0) Share

Report

Posted on by martinav

3,340

Shane young did a good job of explaining how to use Sequence() for incrementing in a ForAll() (Click for Shane's Video) . However, I need to increment inside my ForAll() if a condition is met. Thus, Sequence is a no-go. Since Set() and UpdateContext() arent happy inside ForAll(), is there another option?

Just to start discussion, this is the theory of what I want to do. However, it wont work because UpdateContext() isnt valid.

With({_FData:FilteredData},
 ForAll(_FData,Patch(FilteredData,LookUp(FilteredData,Index=ThisRecord.Index),{GroupIndex:GpIndx});If(LookUp(FilteredData,Index=Index+1).Valve_Type<>ThisRecord.Valve_Type,UpdateContext({GpIndx:GpIndx+1})))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

PaulD1 2,914 on at

Like (3)

Report
Copy link

Link copied!

Although you cannot do a Set or UpdateContext in a ForAll, I believe you can patch to a collection, so you can update a specific record in an existing collection and refer back to it.
Note that ForAll is not guaranteed to process records in order so do be careful if that could be an issue in your scenario.

Was this reply helpful? Yes No
Verified answer

Adrian_Celis 1,652 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @martinav

@PaulD1 is right. What I would do is create a temp Collection and then increment the value there.

Sample:

ClearCollect(collTemp,{Value:0}); With({_FData:FilteredData}, ForAll(_FData,Patch(FilteredData,LookUp(FilteredData,Index=ThisRecord.Index),{GroupIndex:GpIndx}); If(LookUp(FilteredData,Index=Index+1).Valve_Type<>ThisRecord.Valve_Type,Patch(collTemp,First(collTemp),{Value:Value+1}))); UpdateContext({varResult:First(collTemp).Value});

varResult should be your total incremented.

Addt'l notes : You can use With inside a ForAll but I still can't find a way to transfer a With variable to a context or global variable.

Was this reply helpful? Yes No
martinav 3,340 on at

Like (1)

Report
Copy link

Link copied!

@Adrian_Celis

Yes! Patch! I should have thought of that.. I mean, I'm doing that already. Thanks for the reminder!

ROd

Was this reply helpful? Yes No
martinav 3,340 on at

Like (0)

Report
Copy link

Link copied!

@PaulD1

THats an interesting point about records not going in order. I will watch my output. Since this is a one time thing. I can explicity lookup each time, and override the order. GOod point!

Thanks

Was this reply helpful? Yes No