JSON Intro for Microsoft 365 People

[@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!

[@AprilDunnam]

Thanks for watching James! I tried to fit as much as I could while still keeping it under 20 minutes :)

[@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?

[@AprilDunnam]

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!

[@UB-qc8yk]

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

[@AprilDunnam]

Glad you liked it - thanks for watching!

[@careyjohnson6630]

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

[@AprilDunnam]

Thanks so much!

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

[@browngentle1]

This was a really terrific video April! Thank you. I think in

[@AprilDunnam]

Glad you liked it Soumya - thanks for watching!!

[@rudzanitshitamba1859]

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

[@tthoman]

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

[@AprilDunnam]

Glad it was helpful!

[@geralddahl9159]

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.

[@dru6197]

Banger. Keep em comin!

[@AprilDunnam]

Thanks!

[@athompson794]

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 ?

[@AprilDunnam]

Thank you! I kind of cover using HTML for design in Power Apps in this Top 3 uses for the HTML control video: kzbin.info/www/bejne/fqLWh2uahJaCeK8 Let me know if you were looking for something different than that though

[@christellannmataac559]

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.

[@ramonillarramendi3191]

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

[@AprilDunnam]

Awesome glad it helped!

[@michelesarsitis233]

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

[@AprilDunnam]

You're welcome Michele! Love that you're enjoying working with formatted forms!

[@samanthawells8177]

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!

[@yvesmanana8296]

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

[@AprilDunnam]

Thanks for watching Yves - so glad this was helpful for your Power Platform journey!

[@jmateus8]

Great vídeo great vídeo 👏

[@AprilDunnam]

Thank you!

[@djl8710]

Awesome Thanks!

[@AprilDunnam]

no problem - thanks for watching!

[@TheLambo77]

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

[@AprilDunnam]

I have a plan to do an Adaptive Cards 101 video. What specifically do you mean by templating?

[@heatherfeather2621]

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

[@AprilDunnam]

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

[@prizim]

very helpful! thanks!

[@AprilDunnam]

Glad it was helpful!

[@DanielMedic]

Nice video April

[@AprilDunnam]

Thank you so much 😀

[@sundrapillay6668]

Thanks April

[@AprilDunnam]

Thanks for watching

[@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

[@AprilDunnam]

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!

[@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.

[@AprilDunnam]

Sure - thanks for the suggestion and thanks for watching!

[@MizanurRahman-dd5mq]

Awesome

[@AprilDunnam]

Glad you liked it!