Power Automate - Extracting Values from JSON Array

[@captainawesomenz]

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.

[@moelmakrani7116]

Man, this is exactly what I needed to to solve my problem. You rock! Thanks.

[@WalterWhite-qc4sd]

Thanks, very straight-forward and explained in a thorough way.

[@PragmaticWorks]

Glad you enjoyed it!

[@yongpeowlim5049]

Your video has helped me through where I am stuck for days! Thank you!

[@PragmaticWorks]

You are so welcome!

[@mansimalik8826]

Great great video!!! This really helped.

[@luizzzgt]

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!

[@javierlujan7118]

Thank you body! your parse part has helped me wherre I was stuck and spending hours on it!

[@PragmaticWorks]

Glad I could help!

[@jasonblais1667]

you saved me! Thank you! Great explanation!

[@amdaring]

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!

[@sandipansarkar9211]

finishjed watching

[@TroyGerber]

Saved me hours. Thank you

[@PragmaticWorks]

You are welcome!

[@renatorfl]

Thx for the video man. It helped me a lot.

[@reyeslopezerick]

Es justo lo que necesito!

[@tamboleo]

Really well explained and really well done, thank you very much to you sire. ;P

[@PragmaticWorks]

No problem! Thanks for watching!

[@vinayayinapurapu]

nailed it and spot on..

[@MohammadAli-ts2ev]

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?

[@excitedsolutions1255]

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.

[@manuelquintana2225]

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!

[@excitedsolutions1255]

@@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!

[@ravitejaayyagari9151]

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.

[@BG-qi5hs]

That’s not an array… that’s an object