Cloud FlowNotification & ReportingIntermediate

Daily SQL Report Email

On a daily schedule, query all rows from a SQL table (e.g., open support tickets), format them into an HTML table, and email the summary to a distribution list.

SQL ServerOffice 365 Outlook

Unique name

flowLibsDailySQLReportEmailDemo

Publisher

FlowLibs (flowlibs)

Version

1.0.0.1

Components

3 env vars + 1 cloud flow

Request access

Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.

What it does

Overview

FlowLibs - Daily SQL Report Email is an intermediate-level scheduled flow that queries a SQL Server table for open records daily and delivers a professionally styled HTML email report to a distribution list. It demonstrates SQL Server connector integration, dynamic HTML table generation, conditional email branching, and environment variable-driven configuration.

Why you'd use it

Use Case

Operations and project management teams need daily visibility into open support tickets (or any SQL-based dataset) without requiring Power BI licenses or dashboard access. This flow automates the delivery of a summary report directly to their inbox every morning, ensuring no open items are overlooked.

Step-by-step

Flow Architecture

Recurrence - Daily 8AM

Recurrence

Fires every day at 8:00 AM Eastern Standard Time.

Init varSqlTableName

Initialize variable

Reads the `flowlibs_SQLReportTableName` env var (default: `[dbo].[SupportTickets]`).

Init varFilterExpression

Initialize variable

Reads the `flowlibs_SQLReportFilterExpression` env var (default: `Status eq 'Open'`).

Init varReportRecipients

Initialize variable

Reads the `flowlibs_DailyReportRecipients` env var (default: `operations@contoso.com`).

Init varHtmlRows

Initialize variable

Empty string variable used to accumulate HTML table rows.

Get SQL Table Rows

SQL Server - GetItems

Queries the configured table with the OData filter, returning up to 500 rows.

Compose Row Count

Compose

Calculates `length()` of the returned array to determine how many records were found.

Check If Rows Exist

If condition

Branches based on whether the row count is greater than zero.

If rows found3 actions run in series

Loop Through Rows — ForEach iterates over results, appending a styled HTML `<tr>` per row (TicketID, Title, Priority, AssignedTo, CreatedDate) to `varHtmlRows`.
Compose HTML Report — Builds a complete styled HTML email with gradient header, record count badge, 5-column data table, and footer showing table/filter info.

Solution config

Environment Variables

Schema name	Type	Default	Description
flowlibs_SQLReportTableName	String	[dbo].[SupportTickets]	SQL Server table to query (fully qualified, e.g., `[dbo].[SupportTickets]`).
flowlibs_SQLReportFilterExpression	String	Status eq 'Open'	OData filter applied to the GetItems action.
flowlibs_DailyReportRecipients	String	operations@contoso.com	Semicolon-separated email distribution list that receives the daily report.

Auth dependencies

Connectors & Connections

Connector	API name	Actions used
SQL Server	shared_sql	GetItems (query table rows with OData filter)
Office 365 Outlook	shared_office365	SendEmailV2 (deliver report and no-records notification)

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Tweaks & variations

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Change the SQL table: Update the flowlibs_SQLReportTableName env var to point to any table (e.g., [dbo].[Orders], [dbo].[Incidents]).
Adjust the filter: Modify flowlibs_SQLReportFilterExpression to any valid OData expression (e.g., Priority eq 'High', CreatedDate gt '2026-01-01').
Change recipients: Update flowlibs_DailyReportRecipients with semicolon-separated email addresses.
Customize HTML columns: Edit the Append HTML Row action inside the ForEach to map different column names from your SQL table.
Change schedule: Modify the Recurrence trigger frequency, time zone, or schedule as needed.
Adjust row limit: The GetItems action is set to $top: 500; adjust this limit in the action parameters.

Helpers & literals

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

EXPR.01Row count

Counts the rows returned by the SQL Server GetItems action.

workflow definition language

length(outputs('Get_SQL_Table_Rows')?['body/value'])

EXPR.02Null-safe column access

Safely accesses a column inside the ForEach, falling back to 'N/A' when null.

workflow definition language

coalesce(items('Loop_Through_Rows')?['ColumnName'], 'N/A')

EXPR.03Dynamic email subject

Builds an email subject that includes today's date and the record count.

workflow definition language

concat('Daily SQL Report - ', utcNow('yyyy-MM-dd'), ' (', outputs('Compose_Row_Count'), ' records)')

EXPR.04UTC timestamp in report

Used in the HTML report footer to show when the report was generated.

workflow definition language

utcNow('yyyy-MM-dd HH:mm')

Overview

Use Case

Flow Architecture

Recurrence - Daily 8AM

Init varSqlTableName

Init varFilterExpression

Init varReportRecipients

Init varHtmlRows

Get SQL Table Rows

Compose Row Count

Check If Rows Exist

Environment Variables

Connectors & Connections

Customization Guide

Key Expressions

EXPR.01Row count

EXPR.02Null-safe column access

EXPR.03Dynamic email subject

EXPR.04UTC timestamp in report

Comments