Unanswered

Adding column to existing collection

(0) Share

Report

Posted on by menglish

Hello,

I have an existing collection of distinct items. Then I have other collections that gets filtered data from a SharePoint List. I need to add columns to the first collection with sums from those other collections. Suggestions?

Thanks!

//First collection has one unique column:
(ClearCollect(colPANELS,RenameColumns(Distinct(colINV,Panel),"Result","Panel_")));

//Trying to add columns:
AddColumns(colPANELS,
"LoadPhA",Sum(Filter(colPLA,Panel=Panel_),A),
"LoadPhB",Sum(Filter(colPLB,Panel=Panel_),A));

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @menglish,

Do you want to sum total by the same panels in the new column?

Could you please tell me what you colPLA and colPLB looks like?

Show me the data set of the colPLA and colPLB.

colPLA:

Panel A

PLA 1

PLA 2

PLB 3

colPLB:

Panel A

PLB 4

PLB 5

PLA 6

colPANELS:

Panel_ LoadPhA LoadPhB

PLA 3 6

PLB 3 9

Is the above data same as you configure in your scenario? If not, please correct me.

Was this reply helpful? Yes No
menglish 6 on at

Like (0)

Report
Hello,

I've tried to work on this with no luck so far. I am trying to first add columns by doing a lookup to another source. Then adding other columns after doing calculations. There are 4 records in colPANELS and only some values are being added to some of the records (see attached picture). I don't understand why.
(ClearCollect(colPANELS, AddColumns(Distinct(colINV,Panel), "LoadPhA","", "LoadPhB","", "LoadPhC","", "ReadingPhA",LookUp('EQ Panels',Title=Result).IA, "ReadingPhB",LookUp('EQ Panels',Title=Result).IB, "ReadingPhC",LookUp('EQ Panels',Title=Result).IC ))); Concurrent( ClearCollect(colPLA,Filter(colINVP,(Phase="A"||Phase="A/B"||Phase="A/B/C"||Phase="B/C/A"||Phase="C/A"||Phase="C/A/B"))), ClearCollect(colPLB,Filter(colINVP,(Phase="A/B"||Phase="A/B/C"||Phase="B"||Phase="B/C"||Phase="B/C/A"||Phase="C/A/B"))), ClearCollect(colPLC,Filter(colINVP,(Phase="A/B/C"||Phase="B/C"||Phase="B/C/A"||Phase="C"||Phase="C/A"||Phase="C/A/B")))); UpdateIf(colPANELS,true,{ LoadPhA:Sum(Filter(colPLA,Panel=Result),A), LoadPhB:Sum(Filter(colPLB,Panel=Result),A), LoadPhC:Sum(Filter(colPLC,Panel=Result),A) });

Was this reply helpful? Yes No