wow thank you for this video. i was majorly stuck with a flow and filtering an array which despite all logic it kept telling me it was an object, not an array. The general knowledge in this video helped me along but when i saw you create an array variable it all fell into place and i solved my issue!
@khaisevenseven4204 Жыл бұрын
Thank you so much. I've been struggling with understanding this and getting it to work. Your video has been the clearest explanation so far and helped me solve my problem. Thanks again!
@jasonthedogcatcher Жыл бұрын
Thanks for making this video. You made a complex process (for a novice anyway) very simple. Keep up the great work.
@moelmakrani71164 ай бұрын
Man, this is exactly what I needed to to solve my problem. You rock! Thanks.
@WalterWhite-qc4sd2 жыл бұрын
Thanks, very straight-forward and explained in a thorough way.
@PragmaticWorks2 жыл бұрын
Glad you enjoyed it!
@yongpeowlim50492 жыл бұрын
Your video has helped me through where I am stuck for days! Thank you!
@PragmaticWorks2 жыл бұрын
You are so welcome!
@mansimalik88269 ай бұрын
Great great video!!! This really helped.
@luizzzgt2 жыл бұрын
awesome content, thanks for the simplicity and for making it so easy
@richardvr7866 Жыл бұрын
This works perfetcly. Thank you so much. Great video!!!
@PragmaticWorks Жыл бұрын
Glad it helped!
@javierlujan71183 жыл бұрын
Thank you body! your parse part has helped me wherre I was stuck and spending hours on it!
@PragmaticWorks3 жыл бұрын
Glad I could help!
@jasonblais166710 ай бұрын
you saved me! Thank you! Great explanation!
@amdaring4 ай бұрын
you. are. a. lifesaver!!! thank you!
@ahmedragab5755 Жыл бұрын
that was sooooo helpful, thank you so much , god bless you
@PragmaticWorks Жыл бұрын
Thanks for watching!
@husalkahli Жыл бұрын
Thanks a lot man, this is life saving
@PragmaticWorks Жыл бұрын
Thanks for watching!
@sandipansarkar921110 ай бұрын
finishjed watching
@TroyGerber2 жыл бұрын
Saved me hours. Thank you
@PragmaticWorks2 жыл бұрын
You are welcome!
@renatorfl Жыл бұрын
Thx for the video man. It helped me a lot.
@reyeslopezerick2 жыл бұрын
Es justo lo que necesito!
@tamboleo2 жыл бұрын
Really well explained and really well done, thank you very much to you sire. ;P
@PragmaticWorks2 жыл бұрын
No problem! Thanks for watching!
@vinayayinapurapu3 жыл бұрын
nailed it and spot on..
@MohammadAli-ts2ev2 жыл бұрын
Thank you for the informative video. In Power automate/Flow, how can we set the value of cell A2 (of Excel Online for Business) to a variable?
@erinfield1943 Жыл бұрын
2:35- I don't have that Output Body code. I'm in Power BI, in the "Select" connector, and all it gives me for Body output is "[ ]". How do I get the code I need for 5:14?
@youdagoob Жыл бұрын
Thank you for this excellent video. Unfortunately, this doesn't seem to be a possible solution to grab specific data from custom form fields in Microsoft Bookings. Microsoft lumps any and all custom form fields from Bookings into one JSON array called "CustomQuestionAnswers". How do I further parse "CustomQuestionAnswers" from Bookings as individual data points?
@excitedsolutions12553 жыл бұрын
Great video. Do you have any examples that show how to deal with the result of the “execute a query” sql connector? I know the result is formatted in JSON, but I think there’s also a situation where the entire result is “Table1”. I haven’t found any videos that talk about this.
@manuelquintana22253 жыл бұрын
Hello! I am glad you enjoyed the video. The exciting thing is that you can use this same method even when using things like Get Rows V2 or the Execute a SQL query V2. The main thing is how you setup the Parse JSON action. Specifically the "Execute a SQL query (V2) will output three objects that will show up in the dynamic content: Query Results, ResultSets, and ResultSets Table1. I have listed this not in the order they appear in the action but in the order of scope. The higher the scope the more nested arrays and this will require the use of the "Apply to Each" control for the array you want to extract data from. I would recommend looking at the output from the "ResultSets Table1" and using this payload for the "Genarate from sample" option in the Parse JSON action. From there you should get the same capability that I am showing in this video. There is still a possibility that the output will have an array but the beautiful thing is that Power Automate will automatically create the "Apply to Each" control for you and you can still use the dynamic content from the Parse JSON as you please! I just tested this using the Execute a SQL Query (V2) using the ResultSets Output which would guarantee that i would encounter and array and everything worked perfectly! Now it should be noted that if you are getting back some rows and then you want to use only one of the rows from the returned array, things can get a bit tricky there but normally you should be able to find a way to filter your sql query to get back exactly what you need. I hope this helps!
@excitedsolutions12553 жыл бұрын
@@manuelquintana2225 thanks a lot Manuel. I was able to step through as you stated and was able to get the resulting values to use in another step after the query. Thanks again!
@ravitejaayyagari91512 жыл бұрын
Hi can you please tell me how to get 'Yes' value also , and how to store that 'yes' value in variable in above vedio
@youngyingyang Жыл бұрын
I still don't understand why Microsoft is NOT returning labels from Dataverse automatically like it used to with the original D365 Actions and Dataverse Action (Gray ones)... very, VERY stupid.