cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frog64
Helper III
Helper III

Sum array column totally wrong!?

Hi all,

I try to make the sum of an array column for rows that have the same ID.

Someone in this forum told me to have a look at this post, but it doesn't solve my issue: https://powerusers.microsoft.com/t5/Building-Flows/Sum-an-array-column/m-p/794951

 

I hope you can give me good advices and some help on this issue because I am losing a lot of time on this one.

Here is my case.

The array I use is this one:

0001.jpg

 

I make a filter on this array on the RecID field and it looks fine:

002.jpg

 

Here is my flow for this part:

003.jpg

 

004.jpg

 

But the result is totally wrong and I don't understand why.

For example, the value for this ID should be -600: there is only one record for this Recid, and the result returned by my flow is 1200...? and it stores 300 in the Array I use to store the result of my loop 😞

005.jpg

 

I also made a final table, and all is wrong, including the counter that seems crazy:

006.jpg

 

Thanks a lot for your feedback in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Frog64 

 

Here is the video I prepared. Hope this is useful. Let me know about the outcome.

 

https://youtu.be/5PG8bjUXgig

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

4 REPLIES 4
abm
Super User
Super User

Hi @Frog64 

 

Believe you have too many iterations in that logic. Let me try another way and get back to you soon.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @Frog64 

 

Here is the video I prepared. Hope this is useful. Let me know about the outcome.

 

https://youtu.be/5PG8bjUXgig

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Thank you so much for your video, it is very helpful (it solves my issue of course).

It is very informative and it teaches me a lot of things that I absolutely did not know. I think that I don't use Compose enough and that I don't master enough their operations and their calls.

Really thank you!

Hi @Frog64 

 

Thanks a lot for you comments. Really appreciated it. Yes compose is very useful in Power Automate probably my favourite action step 😀 Yes the Select, Filter, Union, XPath all are very useful. Try to avoid iterations as much as you can. That causes the performance issue always and not easy to debug. 

 

If you have any more questions post another thread and happy to help you.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,896)