JSON Intro for Microsoft 365 People
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- #JSON #HowTo
Have you heard about this JSON thing but aren't exactly sure what it is? 🤔 In this JSON intro for Microsoft 365 (aka Office 365) people video I cover everything you need to know about JSON in under 20 minutes. You'll learn what JSON it is, how it works, what it's used for, what tools you need and see examples of how to use it! 😍
I'll show some specific examples of use cases for the Microsoft 365 user including how to use JSON to customize your SharePoint/Microsoft Lists and how to use it to create and share Adaptive Cards via Power Automate. 😮
🔗 Links 🔗
✅ Adaptive Card Designer: adaptivecards.io/designer/
✅ SharePoint List Formatting Samples: github.com/pnp/sp-dev-list-fo...
Table of Contents
00:00 - Intro
00:40 - What is it?
01:15 - What is it used for?
02:32 - How does it work?
05:00 - Tools for working with JSON
06:27 - Fix JSON Mistakes with VSCode Extensions
08:20 - Working with Arrays
09:40 - Use JSON to style SharePoint Lists
15:05 - Use JSON to create Adaptive Cards
15:56 - Using the Adaptive Card Designer
18:20 - Post an Adaptive Card to a Teams Channel with Power Automate
20:26 - Outro - วิทยาศาสตร์และเทคโนโลยี
Don't you just hate it when curly quotes creep in there! Great video though thanks April; there was a lot more packed in there than I was expecting from the title!
Thanks for watching James! I tried to fit as much as I could while still keeping it under 20 minutes :)
This was a really terrific video April! Thank you. I think in
Glad you liked it Soumya - thanks for watching!!
Thank you so much for posting. I love working with my new formatted forms!!!
You're welcome Michele! Love that you're enjoying working with formatted forms!
Thanks for posting this video, that was a great intro to JSON
Glad you liked it - thanks for watching!
Thanx a mil. Was asking that very question in my new journey with Power Platform. Love your videos ❤️
Thanks for watching Yves - so glad this was helpful for your Power Platform journey!
Wonderful video. Thank you very much. Finally got it.
Awesome glad it helped!
Very well done, thank you! This has helped tremendously and look forward to exploring more!
Glad it was helpful!
You are such a great teacher. Thank you so much! This was so great.
Thanks so much!
WOW! This was super helpful April, thanks very much. I've been simply schlogging through copy pasting and praying the JSON works and you've really enlightened me. Too bad msft doesnt provide such useful videos. I had no idea about all this other than msft docs simplistic pages.
How does one learn all this, through Osmosis?
This is going in my April Dunnam folder :)
Banger. Keep em comin!
Thanks!
Awesome Thanks!
no problem - thanks for watching!
very helpful! thanks!
Glad it was helpful!
Thank you for the video! This is a great intro.
Would love to see a follow up video on writing back user inputs from the adaptive card to say a sharepoint list or dataverse record. I imagine the JSON from that would have to be collected with an id to correctly identify the right record to update?
Hey - Thanks for watching! This is a great suggestion - I will add this to my list to do a follow up. There's actually an action in Power Automate to "Post Adaptive Card to Teams and wait for response". You need to have some kind of action like that which keeps a session open to detect a response from the input. If you use that one you can then check what they clicked and then perform an action like create a sharepoint/dataverse record. Hope that gives you a place to start!
Great vídeo great vídeo 👏
Thank you!
Great video!
Also, just wanted to ask on the last bit about adaptive cards. Is it possible to use json file to set dynamic values in the Power Automate instead?
Thanks.
This video was really informative! Thank you for simplifying this concept! I know it may seem unrelated but can you do a video on designing powerapps using css and HTML ?
Thank you! I kind of cover using HTML for design in Power Apps in this Top 3 uses for the HTML control video: th-cam.com/video/HqsV8dO1OBM/w-d-xo.html
Let me know if you were looking for something different than that though
Thanks April
Thanks for watching
Thanks for this video. Any tips on handling nulls in json? I’m not talking about coalesce, instead I mean converting a name value pair into an array like this: {“type”:[“object”,”null”]}. The problem is when the json I’m trying to adjust has nested objects. I tried to insert nulls everywhere I saw “type” and power automate said it was invalid schema. I could try to debug in Visual Code but before I do I’m hoping for a resource or rule of thumb to help me see the big picture so that I can target where in the code I need to insert the null and where it’s deleterious.
Awesome
Glad you liked it!
Hi April. Thanks for this great video! I am EXTREMELY new to JSON and this tutorial was a perfect introduction. I'm not sure if this is the right forum but I have a question about formatting Microsoft List columns. I have created a calculated column "Demographics" which concatenates values from two other columns ( =[Age]&[Sex] ). I would like these values to be displayed on different lines but the JSON does not work(i.e., =[Age]&&[Sex]). Any tips? Thanks again!
Hi April, Great Intro!/ Could you do a video on Templating in adaptive cards
I have a plan to do an Adaptive Cards 101 video. What specifically do you mean by templating?
Hi thanks for the content but is it possible to make a column a read only with Json
Nice video April
Thank you so much 😀
Heheheheh , i know you don't like my sense of humour so i will not crack no jokes :-) Great video even for people who have used JSON or JASON many times
Your sense of humor is just fine , crack away :-) I was making fun of myself when I watched the video back because I couldn't even decide how to pronounce it. In one sentence I would say JSON and the next JASON lol. Thanks for watching!
What are the expressions in powerautomate? Still JSON? Another language?
Hi Heather - Great question - the expressions in Power Automate aren't JSON or any kind of "language" really. The closest thing that I could equate it to would be Excel-like formulas
Can I make a request for a future video? CSV file (either from sharepoint or one drive), convert to JSON, upload into CDS/Dataverse Table. < Trying to parse a CSV file natively in power automate lacks good video content online.
Sure - thanks for the suggestion and thanks for watching!