Avoid duplicate properties with smart JSON parsing in Power Automate #CitizenCan E17 | 365.Training

Buckle up for a swift masterclass in JSON annotations, a wonderful story about Thomas Edison, feeble window sharing, geeky puns and rogue promises with George Doubinski & Amey Holden in this episode of Citizen Can.

The Parse JSON action in Power Automate turns chunks of curly brackets, double quotes, commas, and words into easy to select attributes to use in your flow – nice. But what about when you have more than one attribute with the same name and no description? Is it the ID for the parent record, or for the child records? Choosing the right one can often feel like a game of Russian roulette - but with killer loops instead of bullets.

Learn how to add titles, descriptions, and other useful information into your JSON schema, save the fire playing for another day. Content warning: visual materials contain code, but the outcome is much less terrifying!

Music
---------
Sneaky Snitch by Kevin MacLeod

Marty Gots A Plan by Kevin MacLeod

Semi-Funk by Kevin MacLeod

Shaving Mirror by Kevin MacLeod

Chapters
---------------
00:00 No citizen reaction to the Parse JSON tip of the day
01:04 Sample invoice from Thomas Edison
03:28 Problem with using Parse JSON
07:00 Annotations in JSON schema
09:30 Maker-friendly flow after annotating JSON
11:25 Recommendations when to use schema annotations

[chandrasekharmalla]

This was very nice tip and saves lot of time. Thanks

[juansimon]

Parsing JSON! It felt like magic some time ago. You guys are soo funny.

[alexmcla]

Great tip, thanks! As you say, disappointing it isn’t in the documentation.