SQL Table Row Count Monitor

Overview

FlowLibs - SQL Table Row Count Monitor is a scheduled Power Automate Cloud Flow that monitors SQL Server table sizes by running COUNT(*) queries against a configurable list of tables. When any table exceeds a defined row count threshold, the flow posts a styled HTML alert to a Microsoft Teams channel with a summary table showing which tables are over the limit.

This is a lightweight monitoring pattern ideal for database administrators and developers who want proactive visibility into table growth without setting up dedicated monitoring infrastructure.

Use Case

Database tables that grow unchecked can cause performance degradation, storage cost increases, and compliance issues. This flow provides a simple, scheduled check that answers the question: "Are any of my key tables getting too large?" Examples include monitoring staging tables that should be periodically purged, audit log tables approaching retention limits, or transaction tables nearing capacity thresholds.

Flow Architecture

Environment Variables

Connectors & Connections

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.

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 recurrence schedule

Edit the Recurrence trigger to run daily, hourly, or on a different cadence to match how often you want table sizes evaluated.

Add email notifications alongside Teams

Add an Outlook SendEmailV2 action inside the "If Any Threshold Exceeded" true branch so a parallel email goes to DBAs or an alerts distribution list.

Monitor multiple databases

Wrap the existing logic in an outer ForEach loop over a comma-separated database list (promote a new flowlibs_SqlDatabaseNames env var) so one flow can sweep several databases on the same server.

Add historical tracking

Insert each check's results (table name, row count, timestamp) into a Dataverse table or SharePoint list to build a trend log for capacity planning.

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.

split(variables('varTableNames'), ',')

concat('SELECT COUNT(*) AS RowCount FROM ', trim(items('Loop_Through_Each_Table')))

first(body('Execute_Row_Count_Query')?['resultsets']?['Table1'])?['RowCount']

greaterOrEquals(int(outputs('Parse_Row_Count_Result')), variables('varRowCountThreshold'))

concat('<tr><td>', tableName, '</td><td style="color:red">', rowCount, '</td><td>', threshold, '</td></tr>')