Power Automate – Extracting Values from JSON Array

In this video we will dive into to understanding what certain outputs look like inside of a Power Automate Flow. With this understanding we can then take advantage of the Parse JSON action to extract the information we are looking for that the standard dynamic content might not be able to locate for us. This can make working with complex datatype in Dataverse tables much easier!

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

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

[khaisevenseven]

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.

[yongpeowlim]

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

[WalterWhite-qcsd]

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

[moelmakrani]

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

[luizzzgt]

awesome content, thanks for the simplicity and for making it so easy

[javierlujan]

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

[richardvr]

This works perfetcly. Thank you so much. Great video!!!

[ahmedragab]

that was helpful, thank you so much, god bless you

[husalkahli]

Thanks a lot man, this is life saving

[jasonblais]

you saved me! Thank you! Great explanation!

[renatorfl]

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

[mansimalik]

Great great video!!! This really helped.

[MohammadAli-tsev]

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?

[tamboleo]

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

[erinfield]

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?

[excitedsolutions]

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.

[ravitejaayyagari]

Hi can you please tell me how to get 'Yes' value also, and how to store that 'yes' value in variable in above vedio