No video :(

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

Подписаться 6 тыс.

Просмотров 15 тыс.

50% 1

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.
You can save flow actions and get maximum performance with the xpath method, which is simple to do. Full details on the blog post: www.tachytelic...

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@jasonhawkins3977 11 месяцев назад

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!

@PaulieM 11 месяцев назад

The standard way for large datasets is useless really. Glad it helped.

@JenniferLaveryFBE 6 месяцев назад

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

@PaulieM 6 месяцев назад

Thanks! It’s still more complicated than it should be in my opinion! A dedicated sum action wouldn’t be a bad addition!

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

@jenefermonroe5999 Год назад

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

@PaulieM Год назад

It’s a good (but slightly strange) solution.

@KaranThukral15 2 месяца назад

this video deserves an award!!!!

@PaulieM 28 дней назад

Thank you Karan! Award Accepted 🤣

@josephansah 2 года назад

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.

@PaulieM 2 года назад

Thanks Mojo! Glad you are finding the videos useful. I must do another one soon!

@josephansah 2 года назад

@@PaulieM No rush, but your videos are worth the weight in gold, so please do 🙏🏾 Full of gems with no fluff. I would vote for another example involving the Outlook group HTTP request you previously demoed. Jaw dropped again when you showed what that can do. Best regards.

@madhavadhatrao3528 8 месяцев назад

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

@PaulieM 8 месяцев назад

I appreciate that! Thank you! 🙏

@arshad801 3 года назад

Always good to learn something new

@DaniBored Год назад

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

@PaulieM Год назад

Glad it worked for you. It is a real shame there isn't a built in SUM function.

@gabbyparas6 7 месяцев назад

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

@kingsleyudeagha 2 года назад

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

@PaulieM 2 года назад

Hi Kingsley, I really appreciate the kind words. Thank you 🙏

@RahulSharma-em6en 3 года назад

Thank you very much for such clear and informative video.

@isabellapineda1679 9 месяцев назад

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

@PaulieM 9 месяцев назад

Thank you! I’m glad it helped you out.

@user-uy9ew5my4i Год назад

Thank you. Great tip!

@AlzD3mi4n 8 месяцев назад

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!

@PaulieM 8 месяцев назад

Yes, you can do it in a number of different ways. The best way is to use the user ids to filter the xpath query to get all the data you need in a single action. Then you can use an apply to each on the output and email each user.

@AlzD3mi4n 8 месяцев назад

@@PaulieM In your example how would that be? I'm managing a table with IDs that are repeated in different rows, and I want to summarize the information in just one row with the totals of that particular ID.

@RyanEverhart1350 3 года назад

Worked great! Thank you so much!

@nguyenmanhtuan1772 11 месяцев назад

Its works for me, thank you a lot Sir

@parranoic Год назад

Superb! Thank you

@ThomasPublicThuene Год назад

Wow, that was quick.

@damiandamian3961 2 года назад

How do you do it with a dataverse table

@Hansman 2 года назад

Hi Paulie How do you sum rows using this method?

@PaulieM 2 года назад

Hi Hans, can you explain a bit more about what you mean please? Do you have a row with multiple columns that you want to sum?

@Hansman 2 года назад

@@PaulieM yes multiple columns.

@abcd64709 11 месяцев назад

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

@PaulieM 11 месяцев назад

Use the “take” expression on your array, this will let you specify a number of records to extract from your array.

@vsone9565 Год назад

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

@PaulieM Год назад

Yes, it’s possible to exactly that. I’ve done a couple of demos of this at events - but I can record a new RU-vid video that shows how to do it if that would be useful

@vsone9565 Год назад

@@PaulieM That would be wonderful! No rush, was just thinking out loud - love the idea of avoiding apply to each actions wherever I can

@miltonjuliechapman8824 Год назад

A Video on this would be so helpful. I have attempted to find a solution but have really struggled. Requirement: Each row has a catagory associated by it either via a lookup value or an option set value (Different Tables). I want to list all £ amounts and their associated lookup/option set value set via the record and then sum up based on this.

@clausfraenkel2968 2 года назад

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

@juansepowerplatform 3 года назад

Great to know this. Thank you

@berndkretzschmar5139 Год назад

Chapeau, it really helped.

@ozhally 7 месяцев назад

even better

@Hansman 2 года назад

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

@PaulieM 2 года назад

You can actually do it on multiple columns simultaneously or separately. Can you tell me a bit more about your requirement and perhaps I will do a video on it.

@Hansman 2 года назад

@@PaulieM what I am trying to do is to sum each month of a fiscal year from multiple list which would then be categories on a summary fy list. I think I can do it like you said separately but I want to know how to do it simultaneously. I am progressing in learning power automate thanks to your videos.

@jonmatthews5642 2 года назад

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

@aubreyprice5053 2 года назад

There's a function built into powerautomate you could likely use. Find the max from an output and assign it to a variable.

@Mx81 3 года назад

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

@jonmatthews5642 2 года назад

I had the same issue. I created a filter array to remove all the null/blanks and it worked.

@adrianflores8432 5 месяцев назад

It's laughable that all of this is necessary to... make a sum. Thanks for the video

@PaulieM 5 месяцев назад

Agree, a sum function is required.

@ronakshah6336 10 месяцев назад

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

@AlzD3mi4n 8 месяцев назад

You just create an action> Create HTML Table> then define the headers and the information that will be in the rows, in this case your SUM.

@ImuRazz Год назад

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

@PaulieM Год назад

You would execute multiple xpath queries in a single select action.

@ImuRazz Год назад

@@PaulieM thanks, this was very helpful.

@Zabideen97 24 дня назад

I don't know how it works but it reduced my flow run time from 1 hour to just few minutes.

@PaulieM 24 дня назад

Ha ha, that’s brilliant news! Well done!

@PaulieM 28 дней назад

Check out my new method of summing an array, even easier than this one and no messing around with xpath! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Tz1EONdtqvM.html 🙅