Answered

[HELP] - CALCULATING MULTIPLE COLLECTION

(0) Share

Report

Posted on by Houji

Hi Everyone,

Good day!

I have collection 1 that has data below as an example:

ClearCollect(
 colItems1,
 {Value: 9}, 
 {Value: 10}, 
 {Value: 11}
)

Expected collection 2 value is:

ClearCollect(
 colItems2,
 {Value: 9}
 {Value: 90},
 {Value : 990}
)

So how did the calculation done in step 2 and what I want.
1. Get the first value of the colitems1 and add it to colitems2
2. The first value of colitems2 will be multiplied to the second item of colitems1.

3. The second value of the colitems2 will now be multiplied to the third value of colitems1.

How to do obtain this in powerapps? The value of this collections are not constant. But the flow of the calculation would be like that.

Thank you so much in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Houji ,

I'm just checking with the calculation...
1st collection of 1st item -> 1st item of 2nd collection [Value is 9]
1st Item in collection 2 -> multiply with 2nd item in 1st collection [ 9 x 10 = 90]
2nd item in collection 2 -> multiple with 3rd item in 1st collection [90 x 11 = 990]

Is this correct?
Houji 99 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes correct.

I corrected it already.
Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Houji ,

I did some trial n testing, here's the code
Clear(Col2); ClearCollect( Col1, {Value: 9}, {Value: 10}, {Value: 11} ); Collect(Col2, {Value: First(Col1).Value}); ForAll( LastN(Col1, CountRows(Col1) - 1), Collect( Col2, { Value: ThisRecord.Value * Index(Col2, CountRows(Col2)).Value } ); )

Hope this helps