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!
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.
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!
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?
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.
very well explained. Thanks for that crack!
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 this great video Alireza!
Great, I was looking for this and it brings almost exactly what I needed, Thank you
Thank You for Your work!
excellent tip. compose will do the trick :)
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.
Very very good explanation 👌👌👌👌👌👌
Great content 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.
Alireza, Thank you!
I enjoyed it
it works, thank you!!
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!
Y're the best!!
Thanks very good 👍
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!
Thanks Alireza
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?
I have a large amount data how to intialize
Don't. Look for a third party action who does that.
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
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.
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