JSON Intro for Microsoft 365 People

#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 🔗

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

[wjameswilliams]

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!

[UB-qcyk]

Thanks for posting this video, that was a great intro to JSON

[browngentle]

This was a really terrific video April! Thank you. I think in <20 minutes I understood enough about JSON that I didn't in the last many months. Also great was the Adaptive Card example.

[careyjohnson]

You are such a great teacher. Thank you so much! This was so great.

[alterdom]

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?

[carlw]

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 :)

[tthoman]

Very well done, thank you! This has helped tremendously and look forward to exploring more!

[michelesarsitis]

Thank you so much for posting. I love working with my new formatted forms!!!

[yvesmanana]

Thanx a mil. Was asking that very question in my new journey with Power Platform. Love your videos ❤️

[ramonillarramendi]

Wonderful video. Thank you very much. Finally got it.

[athompson]

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 ?

[christellannmataac]

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.

[rudzanitshitamba]

Hi thanks for the content but is it possible to make a column a read only with Json

[geralddahl]

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.

[samanthawells]

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 <br> does not work(i.e., =[Age]&<br>&[Sex]). Any tips? Thanks again!

[TheLambo]

Hi April, Great Intro!/ Could you do a video on Templating in adaptive cards

[RPAChampion]

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

[heatherfeather]

What are the expressions in powerautomate? Still JSON? Another language?

[sirpentium]

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.