Average total score column IF the ID matches

[msf]

I am trying to build a workflow that will allow me to check the field 'Application ID'. If these match (there should be 3 of them that match) then Average them. Once the math is done,  then to update an item on another SP list using the same column 'Application ID'

[v-bofeng-msft · Accepted solution]

Hi @msf ,

I've made a test for your reference:

1\My SP Lists

2\My flow

Expressions:

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

div(variables('Sum'),length(outputs('Get_items_2')?['body/value']))

Result:

Best Regards,

Bof