hi I would like to format JSON object in emails so it is easily read. The email sends out information in case an error happens and loo

@Ninjasabi{"Key1": "Value1","Key2": "Value2","Key3": { "SubKey1": "SubValue1", "SubKey2": "SubValue2" }} could I have it formatted - see

How to send JSON in email body with nice readable formatting?

To send a JSON object in an email with readable formatting, you can use Power Automate's HTML capabilities to structure the JSON in a way that is easy to read. Here's how you can achieve it:

Step-by-Step Solution

1. Convert JSON to a Readable Format

Use the "Compose" action to pretty-print the JSON.
Use the json() and string() functions:

json(string(<Your JSON Object>))

This ensures the JSON is formatted correctly, even if the structure changes.

2. Format JSON with Line Breaks for Readability

Add the "Compose" action to insert a prettified version of the JSON object:
- Expression to format JSON:
 
 replace(string(<Your JSON Object>), ',', ', ')
- This adds line breaks after each key-value pair.

3. Build the Email Body

Use the "Send an email" action to create a well-structured email body.

Subject: Add a relevant subject line.
Body: Use dynamic content or the Compose output to embed the JSON.
- Example:
 
 An error occurred in one of the flows. Below is the JSON object: <pre style="background-color:#f4f4f4;padding:10px;border:1px solid #ddd;border-radius:5px;"> @{outputs('Compose')} </pre>

Automating for Multiple Flows

Since you’re using a child flow for error handling, ensure that:

Pass the JSON Object to the Child Flow: Add the JSON object as an input parameter to the child flow.
Dynamic Email Body in the Child Flow:
- Use the replace expression (as shown earlier) to format the JSON dynamically.
- Embed the formatted JSON in the email template.

Example Output in the Email

The JSON will appear nicely formatted and easy to read:

Advanced Option: HTML Table Conversion

If you want a cleaner look, convert the JSON into an HTML table for emails:

Use the "Create HTML Table" action:
- Input: Your JSON object.
- Output: A formatted table that you can embed directly into the email.
Embed the table in the email body:

An error occurred in the flow. Below is the JSON data: @{outputs('Create_HTML_table')}

Final Tips

For unpredictable JSON structures, stick to prettified formatting with line breaks (<pre> tags work well).
Use a consistent design with child flows to handle multiple parent flows efficiently.

Let me know if you’d like a detailed walkthrough of any part! 😊

Quick Links

Leaderboard > Power Automate - Building Flows