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:
I make a filter on this array on the RecID field and it looks fine:
Here is my flow for this part:
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 😞
I also made a final table, and all is wrong, including the counter that seems crazy:
Thanks a lot for your feedback in advance!
Solved! Go to Solution.
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!
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.
Keep up to date with current events and community announcements in the Power Automate community.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Check out the latest Community Blog from the community!