Power Apps ParseJSON - JSON is a core skill

[@Joker064460]

Hi Shane, I have to say I am constantly blown away by your ability to explain complex things in such a simple manner! Thank you very much for all the marvelous work you do for all of us! 😊

[@lionking.MuZimba]

Thanks Shane, i must confess, complex json and how to work with it is intimidating. But when you break it down like you do in this video, then i see light at the end of the tunnel and its not a train. Thanks mate!!

[@ShanesCows]

Glad to help. Learning JSON is SOOOOOOOOOO helpful.

[@kimp2002]

I got to the end! Yay! Great intro to ParseJSON for PowerApps. This is another great video I'll be sharing with my team. Thank you!

[@ShanesCows]

Thank you and Thank you. 🤩

[@franknielsen3219]

SO nerdy but yet SO educational!!! Shane, you are a rock star in the Power Apps universe

[@ShanesCows]

Thanks Frank. Have a good day. 🐶

[@absolutelydahling7217]

I've only been building in PowerApps for 2 months now? And wow am I excited. This crash course in JSON has helped monumentaly in my understanding, and now I can load dynamic content from elsewhere in my organization. From no Coding knowledge to a state of confident learning in 2 months. Thanks for the help in getting me here! ( I was one of the 7 that watched until the end, and will likely watch again)

[@ShanesCows]

Thank you for that and enjoy the journey of learning all of this awesome stuff.

[@markjacobson9532]

Great video Shane. I made it to the end. I have used parse JSON in conjunction with PowerAutomate to run stored procedures to bring in data from SQL server and then display it in a gallery. Also use JSON to send data from powerapps via automate and stored procedures to add data to SQL tables.

[@ShanesCows]

Love it and thanks for finding the end. 😎

[@wendymason3263]

Thanks so much Shane, you've taken away the fear of JSON from me and now I'm happy to take a dive into it 🙌🙌🙌🙌

[@ShanesCows]

Awesomeness 🐶

[@Dude276175]

I got to the end! And thanks for addressing the double double quotes. I needed that.

[@ShanesCows]

Awesome. And I agree the double double quotes is one that caused me a lot of pain.

[@ChrisLee-ov2sn]

I really love that you are going back to basics on this kind of stuff. I am able to send my co workers to your vids for reference.

[@ShanesCows]

Awesome Chris. Happy to help and appreciate the sharing. These are cores skills fur sure.

[@jacekbecawski2489]

Thank's Shane for good explanation... I'm sending HI from Poland...

[@ShanesCows]

Awesome, thank you! Have a great week 😎

[@clausdev85]

Hi Shane, great video and thanks for the additional tip on avoiding premium actions

[@ShanesCows]

Happy to help!

[@Francheman]

Brilliant as usual, really appreciate these niche topic videos! Worth it to stick it out to the end as always

[@ShanesCows]

Much appreciated! JSON is super helpful skill to have.

[@oluwatobipaul6171]

Thank you Shane for the expository knowledge on ParseJSON. I NEEDED THIS!!

[@ShanesCows]

You are welcome.

[@jimfitch]

Thank you, Shane! I know I’ve needed to learn this, tried to do it on my own a few times, but gave up for want of basic understanding. Your clear explanations & examples enable me to work on this now. Thanks, especially, for including the lessons at the end about MS’s documentation. It completely mystified me before now.

[@ShanesCows]

Very welcome! Comments like this is why I tackle topics like this. 🤩

[@jimfitch]

@@ShanesCows I’m grateful that you do!

[@baffledbumblebee]

All my questions were answered. I was watching for the json more than the powerapps but I do need to learn more powerapps stuff, so great video!

[@ShanesCows]

Great to hear! JSON is such an important tech skills these days.

[@timwalter6989]

As always, I know so much more after watching your videos than before seeing them. I made it all the way through (mostly to see if there were any post-credit scenes for upcoming videos :) )

[@ShanesCows]

Post credit scenes. Could be fun.

[@interhumangames8525]

Thank you Shane for the great and humorous explanation - just what I needed since I have been avoiding JSON for years now :) Keep it up!

[@ShanesCows]

JSON is a necessary evil, glad I could help. Check out this weeks video where we go the next step and talk to the API. 😎 kzbin.info/www/bejne/pmmoo32LaZiBbZY Even more fun.

[@MaximeBilodeau]

Thank you Shane, this was really helpful and I did watch until the end! Thank you for everything you are teaching!

[@ShanesCows]

You are welcome. As long as people keep watching to learn I will keep making stuff. 😎

[@Eduesd]

I got to the end as well! Great video and thank you very much for sharing your knowledge.

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@spen2431]

Watched all the way though.... Nicely explained. Not got a real world use case yet, but if/when I do - this will be watched again (and again!). Thanks for sharing Shane 💥💥👍👍

[@ShanesCows]

Glad it was helpful and thanks for getting to the end. You are the second person so far. 😎

[@rihabhamila4080]

I had no idea what JSON is used for, now I will feel more confident trying to use it.. and I made it to the end of the Video, Thank you @Shane Young.

[@ShanesCows]

Thanks for sticking it out.

[@JapLomm]

This has been an amazing video. It was hard to understand what actually is JSON but your example was amazing. Thank you.

[@cwanja89]

First and foremost, great video Shane. Really well done, broken down clearly and cleanly (unlike JSON). Now that you are super proficient in JSON, can you do a Power Automate video where you are manipulating and working with JSON? 😊

[@ShanesCows]

A flow Parse JSON video sounds like a solid idea. What would you like to see?

[@matthewbaker4163]

@@ShanesCows Yes a Power Automate Flow JSON video would be great for the 7 of us who loved this one! Maybe if you can cover generating a sample schema - so frustrating and seems to be a different experience every time. Also, when to use Power Automate Parse JSON vs. Select. For context I'm mostly trying to use JSON from SharePoint, also getting into custom connector API output using HTTP calls. Thank you for tackling this topic Shane, very much appreciated.

[@gavinobrien5361]

@ShaneCows, AMAZING video, really helps me a lot to understand a foundational concept in a straightforward way! I'm relatively new to Power Platform, I think reviewing the difference between Select, Filter Array and ParseJSON would be helpful. I use SharePoint a lot and sometimes have trouble with determining the difference between body, value and item with use in flows

[@josephsmith5531]

I would also like to see a video concentrating on JSON within PowerAutomate.

[@nathanhaws5838]

@@ShanesCows Selfishly, I would like to see a video where you build some type of batch job flow, ingesting a report from a OneDrive folder, parsing the data as JSON, doing some processing of that data, then posting the data to a Dataverse table on the backend of a model driven app. I am building a flow like this now, and the very tricky part for me has been the last bit of posting to Dataverse, because I need to check for existing matching records and if yes, then overwrite values, if no then post a new record. There are some filter expressions involved on the Dataverse tables for this and OData and JSON arrays don't play nice together. Anyway. Thanks for the great video fellow Ohioan!

[@emmanuelmaceda2475]

Excellent Shane! Thank you for sharing!

[@ShanesCows]

Glad you enjoyed it!

[@adhuma2000]

Wow, @Shane Young wonderful work. This was absolutely fantastic! 🙌🎥 The way you explained ParseJSON was so clear and easy to follow. I learned a lot and appreciate your dedication to creating such valuable content. Keep up the amazing work! Can't wait for the next one. 👏😊

[@ShanesCows]

Awesome, thank you!

[@debbied9997]

Thanks! I love how to break things down in easy digestable bits, helps with my work indigestion.

[@ShanesCows]

THanks. Appreciate the support Debbie. JSON is so important to learn. It helps with the follow up video on APIs 🤩 kzbin.info/www/bejne/pmmoo32LaZiBbZY

[@RickMohr-o7e]

Thanks, Shane definality needed for those of us who have to manipulate data.

[@ShanesCows]

Agreed. Glad it helped.

[@kurtbarber5117]

watched the whole video. very proud of myself.

[@ShanesCows]

Nice job. Power Apps and Automate are so much better when you understand JSON. 😍

[@stuart-saunders]

I got to the end, yay!! :) Keep up the good work Shane, love it!

[@ShanesCows]

Awesome! Thanks ☺️

[@mr5bassman]

Awesome video! I watched the entire video and it's going into my collection so I'll remember what to do when the time comes. Your work is GREATLY appreciated!

[@ShanesCows]

😎 Thanks for watching it all.

[@TheKermit2110]

Shane, this is probably the most important and useful video i've seen from you in last 12 months (love 'em all obviously) coz i needed a JSON syntax 'building block' tutorial for years! Only thing i was lost on was how you determined the Uri content in your Flow to call the SPO API HTTP?

[@aragaocb]

Good stuff, this will be helpful for api calls for sure. I was using this some but stumble from time to time on errors. Thanks!

[@ShanesCows]

Awesome, glad it helps

[@jamespenna5452]

Great tips Shane, JSON can be very useful

[@ShanesCows]

Absolutely! I really enjoy it now that I understand it better.

[@normanstiegler1275]

Confused but less now thanks to this video. Thank you, this was really helpful.

[@ShanesCows]

Glad it helped! json is tough to understand fur sure

[@davrosmandrake5633]

Yeaaaahhhh I Got to the end....4 months after everyone else....Great Video, as always, You is awesome!

[@ShanesCows]

Yay! Thank you! Better late than never. It was a fun video.

[@LarisseSuzy]

I got to the end! Thanks a lot for sharing your knowledge!😄

[@ShanesCows]

Thank you for sticking it out. 🤩

[@richardrobertson6200]

This is great, I have previously used match all but run into issues later so this will really help handle the data in apps better

[@ShanesCows]

Great to hear!

[@georgewinters2066]

Wonderful ! Clear and concise !

[@ShanesCows]

Thanks George!

[@cmacdhon]

I got to the end!! Awesome video. Thank you Shane. I still hate JSON, but a little less now.

[@ShanesCows]

Awesome. That warms my heart. 😎😎

[@furiousd79]

Super useful. Thanks for explaining this stuff.

[@ShanesCows]

You're welcome!

[@traciwho]

Even though I can barely spell JSON, I've struggled through using it in a couple of apps lately. Thanks so much for breaking it down the "Shane way"! (I'm also one of the seven, btw 😉)

[@ShanesCows]

Awesome and thanks for being part of the seven Traci 👍

[@Unendoras]

Awesome explanation, as always! Keep up the good work!

[@ShanesCows]

Thanks, will do!

[@gavinobrien5361]

Really nice video! Thanks so much for your thorough and helpful explanation :) This will help me better understand and use Power Platform

[@ShanesCows]

Glad it was helpful!

[@davidgrant9474]

Quite useful. A number of ideas came from this. Keep it up.

[@ShanesCows]

Thanks. My 301 live training class today I bet we spent an hour playing with JSON. Crazy how much you can do as you get comfy with it.

[@TheAshtangaLiving]

Thanks Shane ,u are a great teacher 😊

[@ShanesCows]

My pleasure!

[@berggrog1]

Thanks for the video Shane!

[@ShanesCows]

You are welcome. Thanks for watching.

[@malcolmhewlett9121]

I am one of the 7 😀 Love this stuff. Thank you Shane!!!

[@ShanesCows]

Thanks Malcolm 🤩

[@GroverParkGeorge]

I've used the GoogleBooks API in a custom connector, which returns JSON that PowerApps parses internally. It's nice to see how we can get directly at the JSON ourselves and be more precise in targeting data. Cool.

[@ShanesCows]

Awesome! These are exactly the type of 💡 moments I am hoping for. I never know how you will use it, I just want to give you an awesome tool. Have a great day George!

[@li_rens3084]

Thank you Shane, great video.. I was till the end too! From this I'm wondering if it is possible to introduce a search box and search the json data within the gallery and filter the records? that would be a game changer!

[@ShanesCows]

I don't see why not. if your function outputs a table (which it would have to if you are showing it in a gallery) then Search/Filter work on that table. This video on Nested functions might help kzbin.info/www/bejne/n3ibhJ2Nqb1kr68 But yeah whatever you have today, wrap a Search around it and it should just work. I have never tried but I feel good about it.

Hi Shane, thank you very much for this. I've been using the data operations actions and among them Parse Json in Power Automate a lot, but never until now in Power Apps. I've already some ideas where to put the learnings to good use:) oh and I did watch until the end:)

[@ShanesCows]

THANK YOU 😎

[@josephsmith5531]

Great video Shane.

[@ShanesCows]

Thank you

[@kevinflanagan5851]

Thank you for the deep dive i have wasted so much time just looking at JSON and not know what I am looking at. I would see field names and get the point i needed. But this video will help me master it and save me so much time. Thank you and do you recommend any self paced videos to become a power Apps Dev?

[@ShanesCows]

Hey Kevin You can start with the free 101 class. It gives you a great look at most of the Power Platform training.powerapps911.com/courses/power-apps-and-power-automate-getting-started From there if you are looking to get deeper into Power Apps Canvas Apps and Cloud Flows I cannot recommend my 201 class enough. 😎 training.powerapps911.com/courses/powerapps-and-flow-for-app-builders It helps you go from "fake it till you make it" to understanding how all of those crazy tools actually work. 🤩

[@jeanpierreragequit1726]

Thank you so much Shane !!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@patrick2131]

Great job Shane. Just like I needed to understand how to extract a value from a record, this really helps. JSON is nasty to look at. It'd be nice if the Power Platform could use their AI to do the JSON beautify work (sort of like the Format data inside of the Power Fx input field).

[@ShanesCows]

Nice feature idea. 😎

[@mikalaizhalniarkevich9955]

Man, honestly, thank you.

[@ShanesCows]

Happy to help!

[@cjhanzy]

Very helpful, Shane!

[@ShanesCows]

Thanks. It was a struggle to make so glad you liked it.

[@4twt]

Great job clarifying JSON. if possible, put together a video on using JSON within the Microsoft Lists (setting/edit screen). Some how it appears that JSON can be used to format column and row references within Lists prior to creating a canvas app. Would be great to see this in action. Thanks

[@ShanesCows]

Interesting Idea. Thanks

[@klaus6186]

Hi Shane, again a great video. and this gave me an idea. Is it useful to read the json of large SharePoint lists (over 5000 items) and edit them in this way? can you then bypass delegation topics?

[@ShanesCows]

Interesting. Probably worth looking into, I don't see why not but at the same time I have not tried.

[@flyingman09101984]

"I got to the end YAYYY" Here you are :D And thx a lot for your patience! 😄

[@ShanesCows]

Appreciate that and thanks for fighting to the end. 😎

[@flyingman09101984]

@@ShanesCows a real trooper never leaves the battlefield 😎

[@danieljackson1405]

Haven't used Parse JSON yet in PowerApps, so a good heads up for what is coming my way 😆

[@ShanesCows]

Yeah, this is an important one.

[@big1975E]

Great video! Definitely helped me to understand a little more about JSON. While watching I had a crazy idea/question...I have a large SharePoint list as the data source in my app and I need to filter certain records based on the user when the app starts. Currently I bring the list into a collection in chunks of 2000 rows using the ID field. Could I run the flow you showed to call the SP Rest API and bring the entire list in as one big chunk of JSON code, then filter the JSON accordingly? Would this be faster, more efficient, and use less program overhead than building a large collection in chunks of 2000 rows at a time? TIA!!

[@ebutoutusername]

Thanks Shane, really appreciated this video and your hard work. Could you possibly do a video where you extract data from an invoice, then interrogate that data using chatgpt and sometimes do a lookup and then pass the results to a table. e.g. Scan invoice, do ocr on it, use chatgpt prompt to get data from ocr ectraction, so some lookup on vendor name, address etc, then pass the extracted data via json into a sql table

[@ShanesCows]

I have done the invoice scanning part so far kzbin.info/www/bejne/pZipq2p4l7GZrMU

[@ihorzhdanov3584]

Thank you very much! I appreciate it!🙂

[@ShanesCows]

Happy to help

[@Chadstr]

Thank you, needed to get to the end😂

[@ShanesCows]

Congrats. It is fun stuff to learn. 😎

[@yaynative]

Wonderful video!

[@ShanesCows]

Glad you liked it!

[@NunoJSimoes]

very simple. very good

[@ShanesCows]

Thank you! Cheers!

[@ajw99a]

very helpful. Thank you.

[@ShanesCows]

Glad it was helpful! This is such a must learn skill. :)

[@iamintractable1805]

Sean, can you clarify what you meant when you said that a flow returning an array is premium. I don't seen any option for responding to a power app with an array except by placing the JSON in a text return parameter. Is there some other way of responding that supports more data types?

[@ShanesCows]

Response is the name of the action. It is a generic green/teal color.

[@KyleMSchroeder]

Hi, Shane. One powerful thing about JSON in other applications is that it allows developers to reference dynamic objects by using bracket notation. I've been looking to see if this is possible within Canvas Apps, but I haven't found anything. Do you know if this is possible or are we limited to using Dot notation and knowing that property names ahead of time?

[@ShanesCows]

Nothing that I know of Kyle but I haven't tried. 🫤 If you find something let me know.

[@wjameswilliams]

For simple cases, since you're dealing with the JSON string as the input to ParseJSON, you could use Substitute to rename an unknown property name to a known one, then use the known one in your app. For example, if your JSON string was in a variable "varJsonString", you could use: ForAll(Table(ParseJSON(Substitute(varJsonString,$"""{TextInput1.Text}"":","""target"":"))),{target:ThisRecord.Value.target}) Then use .target to reference the only column in this new table, the value of the column being whatever data was in the original column whose name appears in TextInput1. (You would have to be certain "target" would never appear in your origin JSON string!)

[@jonathanbedell7212]

I got to the end!!

[@ShanesCows]

I plug this video all of the time now. I cannot over state how much easier build apps is if you understand JSON. 🤩

[@shishyan2]

Thank you Sir.

[@ShanesCows]

You are most welcome

[@anthonjhnon1]

Do you have a video on how to return JSON Text from a Flow to keep from making it premium?

[@paumason]

Thanks!!! you are awesome

[@ShanesCows]

Thanks, you are awesome for saying I am awesome. 🤩

[@FRANKWHITE1996]

great video

[@ShanesCows]

Glad you enjoyed it, this one seems to scratch an itch a lot of people need.

[@fredericforest1832]

I see it got promoted from Experimental to Preview. Any word as to when they hope to have it in GA?

[@ShanesCows]

I don't know. My rule of thumb is Preview, on by default, is safe but Experimental is no thank you.

[@IamSonoma]

Good video. Double Double Quotes = Quad quotes?

[@ShanesCows]

Change approved 😎

[@jonathanwalker2543]

How do I take an http request in power automate from a graphql query (so NOT a SharePoint list) and put that into PowerApps as a collection or table? If I just take the text output of my Parse JSON action in Automate, I can put that in a text box on PowerApps and use ParseJSON on it in the app. But when I respond to PowerApps flow call, the text is treated like an object and I can’t get it converted.

[@LakshmiPathi-b2t]

Thank You 😊😊

[@ShanesCows]

You're welcome 😊

[@Timmones]

Hi Shane, I am trying to pull down Office365 users from an Office365 group, so I was going to do a call for ListGroupMembers, but I can only bring down 999 users without paginating. If my results exceed that 999 limit, how would I implement this where I can pull down my ~1200 users from my O365 Group into PowerApps as a JSON, parse it, and stuff that in a collection/table?

[@ShanesCows]

The Function has a Next Link that you have to loop through. I know how to do it but I don't have anywhere with more than 1000 users that I can demo on. :( But that is what you are looking for. Hope it helps.

[@Cielu1]

I have done this with a macro under a button, but ye it is paginating wiht Next as Shane said. But i can share my solution with you if you are intrested :)

[@Timmones]

@@Cielu1 That would be awesome!

[@Timmones]

@@ShanesCows Perfect, Shane! And thank you for another great video! :)

[@melissachristensen4498]

Could this For All / AS TABLE Function theory be used to add multiple photos to a html that's being converted to a PDF? It's for uploading receipts. Sometimes those receipts will fit on one photo, but sometimes it will go on multiple pages. I need the PDF To grow or shrink depending on how many photos are uploaded.

[@ShanesCows]

You most likely want to use Concat function to loop through the Table and generate the HTML. Not your exact scenario, but the mechanics are covered here kzbin.info/www/bejne/d5-og5l9fqprndk

[@paolovr1970]

Shane thanks😊

[@ShanesCows]

Thank you! This video is so important, glad you watched it.

[@MrWimstevens]

I got to the end, yeahhhh

[@ShanesCows]

Nice Job Wim! 🤩

[@brokenctrl]

I made it to the end. Yeeeey

[@ShanesCows]

Awesome. Hope you learned lots. JSON is fun😎

[@changakevin8454]

very, good video. Please, can you tell where i can have that file. thank really interesting

[@ShanesCows]

training.powerapps911.com/courses/video-library Thanks!

[@vivekmurli5137]

How do we Parse a collection to JSON to include null values?

[@schattedaenker]

Thanks😊

[@ShanesCows]

No problem 😊 Hope your week is awesome!

[@schattedaenker]

@@ShanesCows studying power apps helps:) Have a great week too

[@ericmild4050]

Made it!!!

[@ShanesCows]

Good Job Eric! I know it was a ruff one. 🐶

[@ShaneC0271]

Well, crap. I completely forgot that you could escape the double quotes that way! I'd be embarrassed to say the number of times I've used single quotes to wrap the keys/values when building a JSON string and then used Substitute to replace those single quotes with doubles before parsing.

[@ShanesCows]

Glad to help 🤩

[@MarkJFellows]

Well, I watched the whole video so I'm now one of the ""Magnificant 7"" ! I just hope I don't need to use it.

[@ShanesCows]

Thanks Mark! I appreciate your dedication, it couldn't have been fun. 🤣

[@changakevin8454]

where can i have those dummy data

[@ShanesCows]

training.powerapps911.com/courses/video-library you can subscribe there and then download it. Everything is on sale through today!

[@SaraHamiltonJD]

Hahaha the bleep. I LOLed.

[@ShanesCows]

I am here to entertain you Sara 😎

[@avecNava]

ParseJSON({""note"":""Thank You""}).note 🙏🙏

[@ShanesCows]

🤩🤣 Good job!

[@thenewnando]

i got to the end heeeeeeeeeeeeeeeeeee

[@ShanesCows]

Awesome and congrats. 🤩

[@johnaweiss]

18:09 You lost me on `collect`. I understand that ForAll is looping the table. So, collect creates a collection for each record in the table. Why? Then you said the collection will create three blank records in the table. You mean "collect" inserts new rows into a table? Why three? Then you said you're creating a new column called "SN". You mean, collect creates new columns in a table?

[@clintro]

I made it!!! LOL

[@ShanesCows]

Nice Job Clint! 🐶

[@davidgraf8012]

Having to become proficient in JSON doesn't seem that compatible with the idea that Power Apps is intended for citizen developers. I'd far rather that MS spent their development efforts beefing up Power Apps to the extent that you don't need JSON.

[@ShanesCows]

I would say the great majority of Power Apps Makers don't do JSON. But those who want to grow and push the boundaries of Low Code I think it is a fun option. I agree that the more JSON, APIs, PCF, etc you get into the less low code the feel. But the fact we can grow with the platform is pretty awesome. I am not a pro dev, never have been, yet I keep learning more stuff like this to build bigger and badder things. 😎

[@jasoncunningham4809]

I got to the end, YAY!

[@ShanesCows]

Thanks. I think you are the fourth. 😂

[@CigarDoug]

I got to the end. Yay!

[@ShanesCows]

Get yourself a Cigar to celebrate Doug. 🤩