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.
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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.