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.
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!
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.
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 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.
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?
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!
Great explanation. The Compose inside a loop in order to get the current attribute is great
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.
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!
Very helpful video. It solved the problem I was having perfectly!
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.
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 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!
Thank You for Your work!
Great, I was looking for this and it brings almost exactly what I needed, Thank you
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.
Thank you for this great video Alireza!
very well explained. Thanks for that crack!
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?
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!
I have a large amount data how to intialize
Don't. Look for a third party action who does that.
Very very good explanation 👌👌👌👌👌👌
excellent tip. compose will do the trick :)
Alireza, Thank you!
I enjoyed it
Great content.
Tried to register other udemy course with promo code but it is expired
it works, thank you!!
Y're the best!!
Great content as always
Thanks Alireza
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.
Thanks very good 👍
How to perform sum of colums
related records of parent record using power automate flow ms crm d365
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