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 what have you tried so far with your flow?
yes, am trying with flows. Please guide me on how to achieve the condition. I have no idea how to solve this.
Does the information you need to average come from power apps?
Check out the new Power Platform Community Connections gallery!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.