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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (1,194)