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

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!

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

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

How to convert the SUM into HTML Table and share it to the email

Thank you Paul. How do you set 100,000 record threshold by the way?

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!

Its works for me, thank you a lot Sir

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

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

Thank you. Great tip!

Superb! Thank you

I have like 8 columns and how can i sum each and append it to the table?

Wow, that was quick.

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 :)

Thank you for your creative solutions - truly helpful.

Is it possible to use this method in a way that sums certain groups of values in an array?

ex.

[
{
"Id": "A",
"quantity": "3"
},
{
"Id": "A",
"quantity": "3"
},
{
"Id": "B",
"quantity": "2"
}
]

Where we want A - 6, B - 2

Chapeau, it really helped.

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

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

Hi Paulie How do you sum rows using this method?

How do you do this on multiple columns on a list ? then get each sum and send it to another summary list?

This worked a treat for me and is soooooo much quicker than an apply to each!

but how can I get the min/max values?

Thanks

J

How do you do it with a dataverse table

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.

Thank you very much for such clear and informative video.

Worked great! Thank you so much!

Great tip.
I run into an error if there are null/blank values included.
I found and tried this one, but I get an "invalid expression" error back:
xpath(outputs('Compose_JSON2XML'),'sum(/root/Numbers[string(number(.)) != 'NaN'])')
Do you know how to handle this?


I also couldn't find a documentation about the xpath function like 'sum'. Would be great to have an overview of the possibilities ;-)

Great to know this. Thank you

Always good to learn something new