⚡ Logic Apps Dashboard Workbook

The Logic Apps Dashboard Workbook provides a centralized view of your Azure Logic Apps Standard workflow executions, helping you monitor performance, track failures, and review trends — all from a single Azure Monitor Workbook.

Important

This workbook uses the default (v1) Application Insights telemetry for Azure Logic Apps Standard. It does not use the newer Application Insights v2 enhanced telemetry (Runtime.ApplicationInsightTelemetryVersion: v2).

If you have enabled v2 in your host.json, the telemetry schema and correlation behavior will differ and some queries may need to be adjusted.

---

📊 Dashboard Tabs

The workbook is organized into the following tabs:

Tab	Description
📊 Overview	High-level KPI tiles (Total Runs, Succeeded, Failed, Cancelled), status distribution pie chart, and execution trend over time
🔴 Failures	Failure analysis — failures by workflow (bar chart), failure trend over time, and a detailed grid of individual failed runs

📊 Overview Tab

🔴 Failures Tab

---

🔎 Queries

All KQL queries used in the workbook are documented in Queries.md for reference, reuse, or customization.

Query	Description
Total Workflow Runs	Total count of all workflow executions
Succeeded Runs	Count of succeeded workflow runs
Failed Runs	Count of failed workflow runs
Cancelled Runs	Count of cancelled workflow runs
Execution Status Distribution	Execution count grouped by status (pie chart)
Execution Trend Over Time	Daily execution trend by status (time chart)
Failures by Workflow	Failed runs grouped by workflow name (bar chart)
Failure Trend Over Time	Daily failure count over time (time chart)
Failed Workflow Runs — Detail	Detailed list of failed runs with run IDs and tracking info

Note

The queries in Queries.md are written for Log Analytics (AzureDiagnostics) as a reference for workspace-based migration. The workbook itself uses the default (v1) Application Insights traces table.

---

🔧 Prerequisites

• Azure Logic Apps Standard (function app kind: functionapp,workflowapp)
• Application Insights resource connected to your Logic Apps
• Logic Apps must be using the default (v1) Application Insights telemetry — i.e. you should not have "Runtime.ApplicationInsightTelemetryVersion": "v2" set in your host.json
• Logic Apps must emit FlowRunLastJob traces to Application Insights

---

🚀 How to use it?

Importing this Workbook to your Azure environment is straightforward.

1. Login to Azure Portal

2. Go to Azure Workbooks (search for "Workbooks" or navigate via Azure Monitor)

3. Click + Create

4. Click + New

5. Open the Advanced Editor using the </> button on the toolbar

6. Select the Gallery Template (Step 1)

7. Replace the JSON code with the contents of Logic Apps.workbook (Step 2)

8. Click Apply (Step 3)

9. Click Save on the toolbar

10. Fill in the save details:

    • Title: Logic Apps Dashboard
    • Subscription: your subscription
    • Resource group: your resource group
    • Location: your region

11. Click Save

The Workbook is ready to use! Open it and configure the filters:

• Subscription — Select the subscription containing your Logic Apps
• Logic App — Filter to specific Logic Apps (or select All)
• Time Range — Choose the time window for analysis
• Application Insights — Select the App Insights resource(s) linked to your Logic Apps

---

📂 Repository Structure

├── 📄 README.md                   # This file
├── 📊 Logic Apps.workbook         # Azure Monitor Workbook (JSON)
├── 📝 Queries.md                  # All KQL queries documented in one file
├── 🖼️ overview-tab.png            # Screenshot of the Overview tab
└── 🖼️ failures-tab.png            # Screenshot of the Failures tab

---

⚠️ Known Limitations

• This workbook uses the default (v1) Application Insights telemetry for Logic Apps Standard. It queries the traces table with operation_Name == "FlowRunLastJob".
• It is not compatible with the newer Application Insights v2 telemetry. If you have enabled "Runtime.ApplicationInsightTelemetryVersion": "v2" in your host.json, the telemetry schema differs and queries will need adjustment.
• The Logic App name filter relies on Azure Resource Graph to discover functionapp,workflowapp resources.

---

📝 Contributing

Contributions are welcome! If you have improvements, bug fixes, or new queries to add:

1. Fork this repository
2. Create a feature branch
3. Submit a Pull Request

---