TL;DR: Use a browser JSON Viewer extension (or Edge’s built-in formatting) to turn raw Power Automate JSON into readable, structured data.
💡 Challenge
Navigating through unformatted JSON data in Power Automate, especially from actions like ‘List Rows’ or ‘Get Items’, is cumbersome and difficult to decipher.
✅ Solution
Use a JSON Viewer extension to transform raw JSON into a readable and manageable format in your browser.
🔧 How It’s Done
1. Install a JSON Viewer
🔸 For Chromium browsers, add a JSON Viewer extension from the store to your browser toolkit.
2. Use Edge’s native formatting
🔸 Microsoft Edge formats JSON responses automatically when you open a .json URL, no extension required.
🔸 For older builds, you can enable it via edge://flags.
3. Enjoy Clarity
🔸 Open your JSON data in a new tab to view it in a structured, easy-to-navigate format.
🎉 Result
By harnessing a JSON Viewer, complex JSON structures become clear and easy to navigate, making your Power Automate data handling more efficient and enjoyable.
🌟 Key Advantages
🔸 Enhanced Clarity: Say goodbye to JSON jumble and hello to structured data.
🔸 Swift Analysis: Accelerate your debugging and data scrutiny.
🔸 User Centric: Enjoy a streamlined, intuitive interface.
🛠️ FAQ
1. Which browsers support JSON Viewer extensions?
Most modern browsers including Chrome, Edge, Firefox, and Safari support JSON viewer extensions or have built-in JSON formatting capabilities.
2. Can I use a JSON Viewer for debugging Power Automate flows?
Absolutely! A JSON Viewer is perfect for examining HTTP responses, webhook payloads, and other JSON data in your flows.
3. Does a JSON Viewer work with large JSON files?
Yes, most JSON Viewer extensions can handle large files, though performance may vary depending on the file size and your browser.
Marcel Lehmann
Microsoft MVP