calculate average based on columnID

[SyedShadab39]

Hi, this is my list, I want to calculate the average of 'TotalPoints' only if 'BoothNumber' is same and store them in another list. 

It has to loop through the list when an item new created. 

if BoothNumber = 2 then update BoothNumber=2, ProjectName=Project1 and AverageScore= (27+0)/2 .

if BoothNumber = 1 then update BoothNumber=1, ProjectName=Project1 and AverageScore = (30+26)/2 . or AverageScore = (30+26+40+29)/4 when count of BoothNumber = 4. 

[SyedShadab39]

Hi, this is my list, I want to calculate the average of 'TotalPoints' only if 'BoothNumber' is same and store them in another list. 

It has to loop through the list when an item new created. 

if BoothNumber = 2 then update BoothNumber=2, ProjectName=Project1 and AverageScore= (27+0)/2 .

if BoothNumber = 1 then update BoothNumber=1, ProjectName=Project1 and AverageScore = (30+26)/2 . or AverageScore = (30+26+40+29)/4 when count of BoothNumber = 4. 

[RobElliott]

@SyedShadab39 what have you tried so far with your flow?

Rob
Los Gallardos

[SyedShadab39]

yes, am trying with flows. Please guide me on how to achieve the condition. I have no idea how to solve this.

[Paulo_VS]

Does the information you need to average come from power apps?