cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SyedShadab39
Helper I
Helper I

calculate average based on columnID

 

2020-02-25_14h43_58.png

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

2020-02-25_14h55_38.png

 

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. 

 

3 REPLIES 3
RobElliott
Super User
Super User

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

Rob
Los Gallardos

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

Paulo_VS
Advocate I
Advocate I

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

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Users online (1,434)