Power Apps ParseJSON - JSON is a core skill
HTML-код
- Опубликовано: 2 авг 2024
- #powerapps #PowerPlatform #CanvasApps
In this video, you'll dive deep into the world of Power Apps and JSON parsing. You'll learn how to take complex JSON data and turn it into something usable in Power Apps. Whether you're dealing with simple key-value pairs or nested arrays and objects, this tutorial has got you covered. You'll also get a glimpse of how to use Power Apps functions like ParseJson, Value, and Text to manipulate the data types and get the results you want. The video even touches on how to use Microsoft Flow to fetch JSON data from SharePoint and parse it in Power Apps. By the end of this video, you'll be a JSON parsing pro, ready to tackle any data structure that comes your way.
0:00 Power Apps ParseJSON Video
1:59 Working with Simple JSON
3:07 Use ParseJSON function in Power Apps
6:08 Explaining More Complex JSON
10:04 Reference a record with ParseJSON
12:52 Work with Date Time JSON
14:49 Turning a JSON Array into a Power Apps Table
17:51 ForAll to turn table into a proper collection
21:05 Filter the JSON Array
22:11 ParseJSON SharePoint data from flow
25:02 Explaining how to use the documentation
Up your Power Apps Skills Today!
Link: www.powerapps911.com/up-your-...
Links from the video
learn.microsoft.com/en-us/pow...
jsonbeautifier.org/
Need some help on something you are working on, contact us!
Link: www.powerapps911.com/contact
PowerApps911
Link: www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane 
Наука
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! 😊
I got to the end as well!
Great video and thank you very much for sharing your knowledge.
Happy to help. Have a great day. 🐶
Brilliant as usual, really appreciate these niche topic videos! Worth it to stick it out to the end as always
Much appreciated! JSON is super helpful skill to have.
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!
Thank you and Thank you. 🤩
SO nerdy but yet SO educational!!! Shane, you are a rock star in the Power Apps universe
Thanks Frank. Have a good day. 🐶
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!
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. 😎 ruclips.net/video/p8ErJU43N74/видео.html Even more fun.
I got to the end! And thanks for addressing the double double quotes. I needed that.
Awesome. And I agree the double double quotes is one that caused me a lot of pain.
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.
Awesome Chris. Happy to help and appreciate the sharing. These are cores skills fur sure.
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!
Great to hear! JSON is such an important tech skills these days.
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 🙌🙌🙌🙌
Awesomeness 🐶
Thank you Shane, this was really helpful and I did watch until the end! Thank you for everything you are teaching!
You are welcome. As long as people keep watching to learn I will keep making stuff. 😎
I got to the end, yay!! :) Keep up the good work Shane, love it!
Awesome! Thanks ☺️
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)
Thank you for that and enjoy the journey of learning all of this awesome stuff.
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!
😎 Thanks for watching it all.
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.
Love it and thanks for finding the end. 😎
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.
Very welcome! Comments like this is why I tackle topics like this. 🤩
@@ShanesCows I’m grateful that you do!
Excellent Shane! Thank you for sharing!
Glad you enjoyed it!
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 :) )
Post credit scenes. Could be fun.
Thank you Shane for the expository knowledge on ParseJSON. I NEEDED THIS!!
You are welcome.
Hi Shane,
great video and thanks for the additional tip on avoiding premium actions
Happy to help!
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. 👏😊
Awesome, thank you!
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 💥💥👍👍
Glad it was helpful and thanks for getting to the end. You are the second person so far. 😎
This has been an amazing video. It was hard to understand what actually is JSON but your example was amazing.
Thank you.
Thanks for the video Shane!
You are welcome. Thanks for watching.
Thanks! I love how to break things down in easy digestable bits, helps with my work indigestion.
THanks. Appreciate the support Debbie. JSON is so important to learn. It helps with the follow up video on APIs 🤩 ruclips.net/video/p8ErJU43N74/видео.html
Wonderful ! Clear and concise !
Thanks George!
Great video Shane.
Thank you
Thank you so much Shane !!
Happy to help. Have a great day. 🐶
I got to the end!! Awesome video. Thank you Shane. I still hate JSON, but a little less now.
Awesome. That warms my heart. 😎😎
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!
Awesome, glad it helps
I got to the end! Thanks a lot for sharing your knowledge!😄
Thank you for sticking it out. 🤩
Awesome explanation, as always! Keep up the good work!
Thanks, will do!
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
Great to hear!
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.
Thanks for sticking it out.
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:)
THANK YOU 😎
Yeaaaahhhh I Got to the end....4 months after everyone else....Great Video, as always, You is awesome!
Yay! Thank you! Better late than never. It was a fun video.
Quite useful. A number of ideas came from this. Keep it up.
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.
Confused but less now thanks to this video. Thank you, this was really helpful.
Glad it helped! json is tough to understand fur sure
Very helpful, Shane!
Thanks. It was a struggle to make so glad you liked it.
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?
Thanks Shane ,u are a great teacher 😊
My pleasure!
Thank you very much! I appreciate it!🙂
Happy to help
I am one of the 7 😀 Love this stuff. Thank you Shane!!!
Thanks Malcolm 🤩
Really nice video! Thanks so much for your thorough and helpful explanation :) This will help me better understand and use Power Platform
Glad it was helpful!
Great tips Shane, JSON can be very useful
Absolutely! I really enjoy it now that I understand it better.
Wonderful video!
Glad you liked it!
Man, honestly, thank you.
Happy to help!
Thanks, Shane definality needed for those of us who have to manipulate data.
Agreed. Glad it helped.
very helpful. Thank you.
Glad it was helpful! This is such a must learn skill. :)
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.
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!
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? 😊
A flow Parse JSON video sounds like a solid idea. What would you like to see?
@@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.
@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
I would also like to see a video concentrating on JSON within PowerAutomate.
@@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!
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 😉)
Awesome and thanks for being part of the seven Traci 👍
I got to the end. Yay!
Get yourself a Cigar to celebrate Doug. 🤩
Thank you Sir.
You are most welcome
Thanks!!! you are awesome
Thanks, you are awesome for saying I am awesome. 🤩
watched the whole video. very proud of myself.
Nice job. Power Apps and Automate are so much better when you understand JSON. 😍
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).
Nice feature idea. 😎
very simple. very good
Thank you! Cheers!
"I got to the end YAYYY"
Here you are :D
And thx a lot for your patience! 😄
Appreciate that and thanks for fighting to the end. 😎
@@ShanesCows a real trooper never leaves the battlefield 😎
great video
Glad you enjoyed it, this one seems to scratch an itch a lot of people need.
Thank you, needed to get to the end😂
Congrats. It is fun stuff to learn. 😎
Thank You 😊😊
You're welcome 😊
Haven't used Parse JSON yet in PowerApps, so a good heads up for what is coming my way 😆
Yeah, this is an important one.
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
I have done the invoice scanning part so far ruclips.net/video/ogFz7BbLfvc/видео.html
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
Interesting Idea. Thanks
I made it to the end. Yeeeey
Awesome. Hope you learned lots. JSON is fun😎
Hahaha the bleep. I LOLed.
I am here to entertain you Sara 😎
I got to the end, yeahhhh
Nice Job Wim! 🤩
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!
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 ruclips.net/video/iG8SjWtX1yM/видео.html
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.
Made it!!!
Good Job Eric! I know it was a ruff one. 🐶
Thanks😊
No problem 😊 Hope your week is awesome!
@@ShanesCows studying power apps helps:) Have a great week too
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!!
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?
Interesting. Probably worth looking into, I don't see why not but at the same time I have not tried.
Do you have a video on how to return JSON Text from a Flow to keep from making it premium?
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?
Response is the name of the action. It is a generic green/teal color.
I see it got promoted from Experimental to Preview. Any word as to when they hope to have it in GA?
I don't know. My rule of thumb is Preview, on by default, is safe but Experimental is no thank you.
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?
Nothing that I know of Kyle but I haven't tried. 🫤 If you find something let me know.
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!)
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.
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 ruclips.net/video/AnERfGIE8gw/видео.html
Good video.
Double Double Quotes = Quad quotes?
Change approved 😎
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.
Glad to help 🤩
How do we Parse a collection to JSON to include null values?
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?
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.
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 :)
@@Cielu1 That would be awesome!
@@ShanesCows Perfect, Shane! And thank you for another great video! :)
very, good video. Please, can you tell where i can have that file. thank really interesting
training.powerapps911.com/courses/video-library Thanks!
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.
Thanks Mark! I appreciate your dedication, it couldn't have been fun. 🤣
I made it!!! LOL
Nice Job Clint! 🐶
where can i have those dummy data
training.powerapps911.com/courses/video-library you can subscribe there and then download it. Everything is on sale through today!
i got to the end heeeeeeeeeeeeeeeeeee
Awesome and congrats. 🤩
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?
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.
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. 😎
I got to the end, YAY!
Thanks. I think you are the fourth. 😂