Get average from a SP list

[nikola_bgd]

Hey all, 

I'm trying to figure how to get an average value from a SharePoint list.

The list looks something like: 

ID Grade

1     4

2     5

3     3

4     2

I will than use the average to send an email. (this part is easy 🙂 )

Any ideas?

Thanks

[okeks]

Basic: Do a loop over all items, sum them up and at the end divide by the number of items.

The "modern" way: https://youtu.be/qsIn0mytC_8?t=289

[v-qiaqi-msft · Accepted solution]

Hi @nikola_bgd,

Do you want to get the average value of the Grade column?

Here is the flow you should configure to achieve your need:

length(outputs('Get_items')?['body/value'])

add(items('Apply_to_each')['Score'],variables('Total'))

div(variables('Total'), outputs('Compose'))

[nikola_bgd]

Hi Qi,

Thx!