Create HTML table in Logic App workflow

Step1: Create a Logic App

1. Go to the Azure portal.
2. Click on Create a resource > Integration > Logic App.
3. Provide a name, subscription, resource group, and location for your Logic App.
4. Click Review + create and then Create.

Step 2: Add a Recurrence Trigger

1. Open your Logic App in the designer.
2. Search for the Recurrence trigger and add it.
3. Configure the recurrence interval (e.g., every day, every hour, etc.).
   • Interval: 1
   • Frequency: Day (or Hour, depending on your requirement)

Step 3: Initialize a Variable with JSON Data

1. Add a new action after the Recurrence trigger.
2. Search for Initialize variable and add it.
3. Configure the variable:
   • Name: jsonData
   • Type: String
   • Value: Paste your JSON data as a string. For example:

     [
       { "id": 101, "name": "Priya Singh", "email": "priya@example.com" },
       { "id": 102, "name": "Jane Smith", "email": "jane@example.com" }
     ]

Step 4: Parse JSON Data

1. Add a new action after the Initialize variable action.
2. Search for Parse JSON and add it.
3. In the Content field, select the jsonData variable.
4. Provide a JSON schema for the data. For example:
   {
     "type": "array",
     "items": {
       "type": "object",
       "properties": {
         "id": { "type": "integer" },
         "name": { "type": "string" },
         "email": { "type": "string" }
       }
     }
   }

Step 5: Create an HTML Table

1. Add a new action after the Parse JSON action.
2. Search for Create HTML table and add it.
3. In the From field, select the output of the Parse JSON action.
4. The Logic App will automatically detect the columns (id, name, email) from the JSON data and create an HTML table.

Step 6: Send an Email with the HTML Table

1. Add a new action after the Create HTML table action.
2. Search for Gmail (or your email provider) and select Send email (V2).
3. Connect to your email account.
4. Fill in the email details:
   • To: Recipient email address
   • Subject: HTML Table Report
   • Body: Insert the output of the Create HTML table action.
5. Optionally, you can format the email body with additional text. For example:
   Here is the report:
   @{body('Create_HTML_table')}