Power Automate: Understanding how to use JSON [Power Automate Basics Series - Ep. 6]

In this episode of the Power Automate Basics series, Jonathon Silva provides an in-depth look at using JSON in Power Automate. If you're new to Power Automate, understanding how to work with JSON (JavaScript Object Notation) is crucial, as it allows you to efficiently manage and parse data within your automated flows. Let's dive into how JSON can be parsed and utilized in Power Automate workflows.

What is JSON?

JSON is a lightweight data format that's easy to read and write. It's used to represent data structures such as arrays and objects. When working with Power Automate, JSON allows you to pass and manipulate data in a way that's both flexible and understandable. Here’s a brief overview of how JSON is structured:

• Array: A collection of values enclosed in square brackets.
• Object: A set of key-value pairs, with each key separated from its value by a colon.

How JSON Works in Power Automate

Jonathon walks through an example using a simple flow. A "Compose" action is used to create a basic JSON array. This array contains objects, each representing a row of data, with the properties "name," "company," and "lucky number." Understanding this structure is important as these properties can later be accessed and used within the flow’s actions.

Testing the JSON Array

Jonathon demonstrates how to test the JSON array. The output shows the array in a readable format, where each "object" is a data element, and the name-value pairs act as the individual data points that will be used later in the flow.

Using Parse JSON to Extract Data

One of the most important steps in working with JSON is parsing the data. When you pull in a JSON object into Power Automate, you often see the entire array, but not the individual properties within each object. This is where the Parse JSON action comes into play.

• Step 1: Add a Parse JSON action to your flow.
• Step 2: Provide the content to parse—this is typically the output of a previous action, like "Compose."
• Step 3: Generate a schema from the sample data. This allows Power Automate to understand what each piece of data represents (e.g., strings, integers).

By parsing the JSON, you can now access specific fields such as "name," "company," and "lucky number" individually and use them as dynamic content in other actions.

Practical Example: Sending an Email

Jonathon demonstrates how to extract values from the parsed JSON and insert them into an email. For example, you can dynamically insert someone's name, company, and lucky number into the email body. This is especially useful for personalized emails or notifications based on automated flows.

Handling Complex JSON Data

In some cases, the JSON you work with might contain arrays inside arrays or nested objects. This complexity requires additional parsing steps to extract the specific data you need. Jonathon advises that with careful attention to the schema and understanding of how to navigate through nested arrays, you can handle even complex JSON data.

Why JSON Skills Matter in Power Automate

Having a solid understanding of JSON in Power Automate is a valuable skill. It enhances your ability to troubleshoot errors, handle dynamic data, and build more powerful and flexible flows. JSON parsing is especially useful when working with external APIs, databases, or other data sources that output data in JSON format.

As you continue to use Power Automate, you will find that mastering JSON enables you to streamline your processes, automate more complex tasks, and improve the efficiency of your workflows.

Conclusion

Jonathon’s episode on using JSON in Power Automate serves as an excellent foundation for beginners. Understanding how to parse and work with JSON opens up many possibilities for automating tasks and manipulating data within Power Automate. Whether you’re sending emails, working with API data, or processing complex datasets, JSON parsing is an essential tool in your automation toolkit.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power Automate and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.