Learn JSON for Power Automate with Andrew Perez. Understand objects and arrays, use Parse JSON and Compose, and reshape data so your flows pass clean, reliable payloads step to step.
In JSON for Power Automate, Andrew Perez walks you through JSON in a practical way by building it from scratch. You’ll start with the basics—what JSON is and why Power Automate uses it—then create your own custom JSON object and learn how to make it usable inside a flow. Step by step, you’ll see how that object turns into something you can reference, map, and reuse, then apply it in a real-world scenario so it feels less abstract and more like a tool you can rely on.
From there, you’ll expand into working with arrays and the Select action to shape and transform data for downstream steps. Andrew shows how to take messy or complex data and simplify it into the exact structure your flow needs, whether you’re sending an email, updating a data source, or looping through items. The course wraps with a recap and next steps so you not only understand JSON conceptually, but also feel confident creating, adjusting, and using it in everyday Power Automate solutions.
Course Outline ( Free Preview)
Module 01 - Introduction
In this module, Andrew Perez introduces the importance of JSON (JavaScript Object Notation) as a key skill to advance your Power Automate expertise beyond the basics. He explains how JSON structures data into readable key-value pairs and demonstrates its pervasive role behind the scenes in Power Automate flows. By understanding and manipulating JSON, students will unlock more advanced automation capabilities and gain deeper insight into how Power Automate processes data.
Module 02 - Creating a Custom JSON Object
In this module, Andrew Perez guides students through creating a custom JSON object within Power Automate to deepen their understanding of JSON structure and syntax. By building a personalized JSON record, including nested objects and arrays, learners gain practical experience with key concepts like data types, nesting, and proper formatting. This foundational skill prepares students to effectively manipulate and extract data from JSON in subsequent modules.
Module 03 - Making Our JSON Object Usable8 min.
In this module, Andrew introduces the Parse JSON action in Power Automate, a crucial tool for extracting individual values from complex JSON objects that don’t readily appear in dynamic content. He demonstrates how to generate a schema using a sample payload to simplify parsing and shows how to apply parsed data dynamically within a flow, such as sending personalized emails. This lesson equips students with practical skills to handle nested JSON data effectively, preparing them for real-world automation scenarios.
Module 04 - Real World Application10 min.
In this module, Andrew demonstrates how to apply JSON parsing in real-world scenarios using Power Automate, focusing on making custom API calls to retrieve and manipulate data. He guides students through creating an HTTP request action, handling JSON responses, and using the Parse JSON action to extract individual data elements for practical use, such as sending customized emails. This lesson highlights the importance of understanding JSON structure to extend Power Automate’s capabilities beyond preset connectors and prepares learners for more advanced data handling concepts.
Module 05 - Arrays12 min.
In this module, Andrew explores the concept of arrays in JSON, explaining how arrays can hold multiple items such as values or objects and how to interact with them in Power Automate. The lesson covers practical techniques for manipulating arrays, including using key functions like join, first, last, and split to extract and format array data effectively. By mastering these functions, students will be able to control how array data is processed and displayed within their workflows.
Module 06 - Select16 min.
In this module, Andrew Perez explores the use of the Select action in Power Automate to handle complex array scenarios, particularly when values need to be passed both as an array and as individual items. He demonstrates how to transform and map array data from Microsoft Forms to SharePoint lists, ensuring that multiple selections are correctly recognized and processed for accurate data analysis. This lesson equips students with practical techniques to manipulate JSON data structures effectively within Power Automate flows.
Module 07 - Class Wrap Up1 min.
Congratulations on making it through JSON for Power Automate! In this final module, we’ll quickly recap what you’ve learned—from building custom JSON objects and arrays to shaping data with Select—and highlight when to use these patterns in real flows. You’ll leave with clear next steps and the confidence to read, create, and reuse JSON in your own automations.
Andrew Perez graduated from the University of North Florida with a bachelor’s degree in Transportation and Logistics. He has been working in leadership and management positions since the age of 19, which developed in him a passion for training and helping other to grow. He now puts these skills to work with Pragmatic Works, helping customers bolster their professional skillsets as many mentors have aided him.
.png)