I've got some really *woof* tedious counting to do and your video (by half way through) got me done with a good chunk of it. I really appreciate the tutorial!
I cannot thank you enough. Complicated but very well explained in stages. I liked that you wrote a visual at the start to see all the tables that we will need.
Thanks for this Alireza - it shows some great concepts and takeaways, even if it's not a 'preferred' method of summing values in arrays. Great job, as always!
Hi, thanks for the content, I went to your JSON course, Helpful. To add a comment, I can tell that if we perform this in a large dataset, it will take more than 40 minutes flow to finish.
Thank you for this video! I think this solution may become too bulky very quickly for my purposes; what connectors would you recommend for performing this action? I am so frustrated!
I like that compose trick! Not sure if you mentioned it but is there a reason you're not using Union to get the unique emails or the Xpath with Sum to calculate your sum? Seems like two ApplyToEachs will slow down performance.
Hello Alireza, why you don't use the expression "Union" in the same array, to get the distinct users list? I believe this is more efficiently that apply to each :)
In the sum of numbers u can use xpath to read one xml json with the values in he, it's more efficient too, this method sum 100 m values about in 1 second
Not for that reason, spreading the knowledge that we get along the developments is something always welcome all over the world! :) Power Automate is amazing!
Thanks for this, Alireza, but can you create the same procedure like this but compare values from two sources, which are Excel and sharepoint and generate a new Excel report
Great as always, Thanks Alireza! I'm wondering if it's possible to use a similar approach to create an XML file with a defined schema using apply to each based on a CSV file?
Great video Ali. Thinking if this can be used in our transport booking app we are trying to build. BTW, can the powerautomate expressions and checks be used as commands in powerautomate, like use ForAll to loop and if conditions? Just curious if that would speedup the calculation?
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Great explanation. The Compose inside a loop in order to get the current attribute is great
I've got some really *woof* tedious counting to do and your video (by half way through) got me done with a good chunk of it. I really appreciate the tutorial!
I cannot thank you enough. Complicated but very well explained in stages. I liked that you wrote a visual at the start to see all the tables that we will need.
Thank you, this was really helpful!!
Very helpful video. It solved the problem I was having perfectly!
Thanks for this Alireza - it shows some great concepts and takeaways, even if it's not a 'preferred' method of summing values in arrays. Great job, as always!
Thank You for Your work!
very well explained. Thanks for that crack!
Great, I was looking for this and it brings almost exactly what I needed, Thank you
Hi, thanks for the content, I went to your JSON course, Helpful.
To add a comment, I can tell that if we perform this in a large dataset, it will take more than 40 minutes flow to finish.
Thank you for this great video Alireza!
Very very good explanation 👌👌👌👌👌👌
Thank you for this video! I think this solution may become too bulky very quickly for my purposes; what connectors would you recommend for performing this action? I am so frustrated!
hey! Alireza, how can i do this when i have multiple columns to groupby?
I like that compose trick! Not sure if you mentioned it but is there a reason you're not using Union to get the unique emails or the Xpath with Sum to calculate your sum? Seems like two ApplyToEachs will slow down performance.
excellent tip. compose will do the trick :)
Hello Alireza, why you don't use the expression "Union" in the same array, to get the distinct users list?
I believe this is more efficiently that apply to each :)
You are right. I didn't even think about union when making this video.
Thank you!
In the sum of numbers u can use xpath to read one xml json with the values in he, it's more efficient too, this method sum 100 m values about in 1 second
Not for that reason, spreading the knowledge that we get along the developments is something always welcome all over the world! :)
Power Automate is amazing!
Great content as always
Thanks for this, Alireza, but can you create the same procedure like this but compare values from two sources, which are Excel and sharepoint and generate a new Excel report
Great as always, Thanks Alireza! I'm wondering if it's possible to use a similar approach to create an XML file with a defined schema using apply to each based on a CSV file?
it works, thank you!!
I have a large amount data how to intialize
Don't. Look for a third party action who does that.
Y're the best!!
Great video Ali. Thinking if this can be used in our transport booking app we are trying to build. BTW, can the powerautomate expressions and checks be used as commands in powerautomate, like use ForAll to loop and if conditions? Just curious if that would speedup the calculation?
I have a question regarding the unique user part, why don't we use union expression to get all the unique user list? will that be easier?
Yes it is. I was not thinking about union when I was recording it.
I enjoyed it
Great content.
Tried to register other udemy course with promo code but it is expired
How to perform sum of colums
related records of parent record using power automate flow ms crm d365
Thanks very good 👍
Alireza, Thank you!
Thanks Alireza
how about i want to group it by "user" and "department" for example,
{
"user": "user-A",
"department": "dept-1",
"duration": xxx
}
damn PowerAutomate is definetly not a real ETL, can be done in one step in Talend or Pentaho.....
I agree with you 100 percent. Still I am wondering why aggregate functions are not available in power automate