Answered

[HELP] FOR LOOP INCREMENT VARIABLE

(0) Share

Report

Posted on by Houji

Hello Everyone!

Good day!

I want to increment inside ForAll. My expected output is to get value of ID: 2 AND 4. because the counter value is 2.

How to correct this? Thanks in advance

Clear(newCollection);
Clear(Counter);
Set(varID, 0);
Set(varCounter, 2);
Set(varCounter2, 1);
ClearCollect(
 colTestItems,
 {ID: 1, Value: "13.54"},
 {ID: 2, Value: "15.54"},
 {ID: 3, Value: "14.54"},
 {ID: 4, Value: "16.54"},
 {ID: 5, Value: "18.54"},
 {ID: 6, Value: "12.54"}
);

ForAll(
 FirstN(colTestItems, 2),
 Collect(Counter, 2); 
 Collect(newCollection, {Value: LookUp(colTestItems, ID=varID+CountRows(Counter)).Value });
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Houji ,

Are you trying to achieve this?
ForAll( Sequence(2, 2, 2), With ( {currentIndex: Value }, Collect ( newCollection, { Value: LookUp(colTestItems, ID = currentIndex, ThisRecord) } ) ) )

Hope this helps

Was this reply helpful? Yes No
Houji 99 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ethan_R ,

This is way correct.

But I want to have this

rather than this. This is the result of your code above

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Houji ,

ThisRecord gives complete record as collection.
You can use 'ThisRecord.Value' or any column name after '.' operator.

Hope that helps

Was this reply helpful? Yes No