cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SyedShadab39
Level: Powered On

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
Super User
Super User

Re: calculate average based on columnID

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

Rob
Los Gallardos

Highlighted
SyedShadab39
Level: Powered On

Re: calculate average based on columnID

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

Paulo_VS
Level: Powered On

Re: calculate average based on columnID

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

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (8,782)