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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.