cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
msf
New Member

Average total score column IF the ID matches

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'

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @msf ,

 

I've made a test for your reference:

1\My SP Lists

vbofengmsft_0-1653535249217.jpegvbofengmsft_1-1653535256062.jpeg

2\My flow

 

vbofengmsft_2-1653535274475.jpeg

vbofengmsft_3-1653535279535.jpeg

vbofengmsft_4-1653535285149.jpeg

vbofengmsft_5-1653535293855.jpeg

Expressions:


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

 

div(variables('Sum'),length(outputs('Get_items_2')?['body/value']))
 
Result:
vbofengmsft_6-1653535341639.jpeg

Best Regards,

Bof

 

 

 

 

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @msf ,

 

I've made a test for your reference:

1\My SP Lists

vbofengmsft_0-1653535249217.jpegvbofengmsft_1-1653535256062.jpeg

2\My flow

 

vbofengmsft_2-1653535274475.jpeg

vbofengmsft_3-1653535279535.jpeg

vbofengmsft_4-1653535285149.jpeg

vbofengmsft_5-1653535293855.jpeg

Expressions:


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

 

div(variables('Sum'),length(outputs('Get_items_2')?['body/value']))
 
Result:
vbofengmsft_6-1653535341639.jpeg

Best Regards,

Bof

 

 

 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,986)