Power Platform Community Forum Thread Details

I have created this collection in my app:

ClearCollect(colAssetsTotal,
    AddColumns(GroupBy(colAllEquipment, phase, equipment, GroupedByItem),  
        EquipmentSum, Sum(GroupedByItem, WeightedCompleted*100),
        PhaseWeighting, Switch(phase, "Design Data", 0.4, "Fabrication Data", 0.2, "As-Built Data", 0.3, "Commissioning Data", 0.1))) 
 
What I want to do is add a column to the collection which multiplies EquipmentSum by PhaseWeighting.
If I try to add the column within the AddColumns statement, then it doesn't recognise the two columns previous to it.
If I add a new AddColumns like below, then I get an error that the new column name has already been used. 
I've tried different names and the error is the same.
The last thing I tried was to use the AddColumns formula outside of the ClearCollect and after it. 
No errors with this, but the column doesn't show in my table after running and can't be referenced.
Do I need a With statement to get this to work?

Categories:

Building Power Apps

Hi CAlvy

You need to do this

ClearCollect(
   colAssetsTotal,
   AddColumns(
      AddColumns(
         GroupBy(
            colAllEquipment, 
            phase, 
            equipment, 
            GroupedByItem
         ),  
         EquipmentSum, 
         Sum(
            GroupedByItem, 
            WeightedCompleted * 100
         ),
         PhaseWeighting, 
         Switch(
            phase, 
            "Design Data", 
            0.4, 
            "Fabrication Data", 
            0.2, 
            "As-Built Data", 
            0.3, 
            "Commissioning Data", 
            0.1
         )
      ),
      SumWeight,
      EquipmentSum * PhaseWeighting
   )   
)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee