Power Automate - Extracting Values from JSON Array
ฝัง
- เผยแพร่เมื่อ 18 มิ.ย. 2024
- 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!
If you enjoy this video or any of my other videos and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Manuel20" to get an extra of 20% off at check out when purchasing our On-Demand Learning classes from pragmaticworks.com/pricing/ #ManuelQuintana
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses Free Trial: www.pragmaticworkstraining.co...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️TH-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 413-1911
Email: training@pragmaticworks.com
![DAX - Creating Dynamic Titles [Demo]](http://i.ytimg.com/vi/lbqiAcCbiu4/mqdefault.jpg)
![DAX - Creating Dynamic Titles [Demo]](/img/tr.png)
you. are. a. lifesaver!!! thank you!
Man, this is exactly what I needed to to solve my problem. You rock! Thanks.
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!
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!
Thanks for making this video. You made a complex process (for a novice anyway) very simple. Keep up the great work.
Great great video!!! This really helped.
Thx for the video man. It helped me a lot.
awesome content, thanks for the simplicity and for making it so easy
Thanks, very straight-forward and explained in a thorough way.
Glad you enjoyed it!
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?
This works perfetcly. Thank you so much. Great video!!!
Glad it helped!
Your video has helped me through where I am stuck for days!
Thank you!
You are so welcome!
you saved me! Thank you! Great explanation!
Thank you body! your parse part has helped me wherre I was stuck and spending hours on it!
Glad I could help!
that was sooooo helpful, thank you so much , god bless you
Thanks for watching!
Thanks a lot man, this is life saving
Thanks for watching!
Saved me hours. Thank you
You are welcome!
nailed it and spot on..
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.
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!
@@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!
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?
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?
Really well explained and really well done, thank you very much to you sire. ;P
No problem! Thanks for watching!
Es justo lo que necesito!
Hi can you please tell me how to get 'Yes' value also , and how to store that 'yes' value in variable in above vedio
finishjed watching
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.
That’s not an array… that’s an object