How to instantly sum an Array of numbers in a Power Automate Cloud Flow

This is the ultimate performance method of summing an array in Power Automate. I used this method to sum an array of 100,000 records in less than 1 second using the powerful xpath function. Normally you would use an apply to each loop, but with this method there is no need.

[jasonhawkins]

You bloody Legend! I'll never sum the standard way again! For big datasets this is the only way to sum without it taking literal hours. Thanks Paulie!

[takocalvin]

Thank you for revealing the hidden gem! I couldn't sum or set a variable inside the "Apply to each" action.

[zYxMa]

Amazing solution. Why didn't Microsoft include a SUM function is beyond me, yet this is extremely simple and will potentially save hours (and in some cases DAYS!!!) in generating reports for me :)

[jenefermonroe]

Wow! This was amazing. I'm glad I didn't give up before I found your video!

[madhavadhatrao]

You are the best Paul. Such great content, Thank you so much

[josephansah]

Thank you very much Paulie. Recently discovered your videos and I must say that I really enjoy good content. I have watched a few and learnt something different and not so obvious in all of them; straddles the line between intermediate to pushing on advanced learning. Maybe not in this simpler example, but at least in the other videos I have seen 🙂 More grease to your elbows.

[dexter]

You made my day with this video, thank you! :)

[JenniferLaveryFBE]

Finally! Something that doesn't seem needlessly convoluted. :)

[AthertonSquire]

Paul thank you for this worked a treat

[RahulSharma-emen]

Thank you very much for such clear and informative video.

[DaniBored]

Thank you sir, you saved me. I had been trying to do this for a day ! 😄

[kingsleyudeagha]

You are the best Paul. Such great content for free. Amazing.

[gabbyparas]

Thank you for this. Question, how can I add multiple columns?

[adrianflores]

It's laughable that all of this is necessary to... make a sum.

Thanks for the video

[damiandamian]

How do you do it with a dataverse table

[DavidBambino]

Hi Paul! Your video has helped me a lot to improve my performance. I wanted to ask you how I can add that final result to an HTML table and send it by email? I want to simulate adding up the entire column.
I'd appreciate it.

[clausfraenkel]

You use this approach to sum 100.000 rows but how do you set this up with “get items” - i have problems with limit on that

[nguyenmanhtuan]

Its works for me, thank you a lot Sir

[isabellapineda]

Muchas Gracias, dure mucho buscando información sobre como sumar una Columna, que no fuera con incremento que pasara por cada registro de obtener elemento, muy valioso el aporte muchas gracias

[AlzDmin]

Thank you, Paul! Your video is amazing!
I wonder if there is a way to filter the information to send it to specific users, in your example, sum only the invoices from ID 1 and send it to user 1?

Thank you in advance for your help!