Power Platform Community Forum Thread Details

I want to implement a solution in Microsoft Purview that allows me to receive an email notification when a column in a table is automatically classified during a scan.

The scenario is as follows:

* I have a data source in Dataverse registered with Microsoft Purview.

* A classification scan is run on that source.

* Once the scan is complete, and if any column has been classified (for example, with sensitive information labels), I need to generate an automatic alert.

My goal is to:

* Detect when a column changes or receives a classification.

* Trigger an email notification at that moment.

I am evaluating whether this can be achieved through integration with Power Automate, for example:

* Using Microsoft Purview events, triggers, or APIs.

* Or by consuming scan logs/results to trigger a workflow.

Is it possible to implement this workflow with Power Automate? If it's not straightforward, what additional architecture or components would be required (e.g., Azure Event Grid, Purview APIs, etc.)?

Categories:

Connector development

Hi @CU23042111-0,

You cannot directly trigger Power Automate when a column is classified during a Purview scan. There is no native Purview trigger or event that fires at column‑classification time.

However, this is achievable with supporting Azure components.

Why it’s not straightforward

Microsoft Purview does not emit scan‑level or classification‑change events that Power Automate can subscribe to.
There is no built‑in Purview connector or trigger for “column classified” or “scan completed with new classifications”.
Power Automate alone cannot poll Purview scan results without calling APIs.

Supported architecture that works

Recommended pattern

Purview APIs + scheduled automation + Power Automate

Run your Purview scan normally
Dataverse is scanned and classifications are applied to columns.
Poll scan metadata using Purview APIs
Use:
- Purview Catalog REST APIs
- Classification or asset metadata endpoints

This lets you detect newly classified or changed columns.

Compare results
Store previous scan metadata (for example in Blob storage, Table storage, or Dataverse).
Detect differences such as:
- New classification added
- Classification label changed
Trigger your notification
Once a change is detected:
- Trigger Power Automate via HTTP
- Or send the email directly from Azure Logic Apps or Azure Functions

Typical implementation options

Option 1: Azure Logic Apps or Power Automate + HTTP

Recurrence trigger
HTTP call to Purview APIs
Parse scan results
Condition to detect new classifications
Send email alert

Option 2: Azure Function (more scalable)

Timer triggered function
Calls Purview APIs
Diffs scan results
Sends Event Grid message or calls a flow
Power Automate handles notifications

Option 3: Event-driven (limited today)

Purview does support Event Grid for some governance events
Classification scan results are not currently included

Important notes

There is no near‑real‑time alert for column classification today.
All solutions rely on post-scan inspection of metadata.
This limitation applies to Dataverse and other Purview data sources.

Bottom line

✅ Goal is valid and common
❌ Not achievable with Power Automate alone
✅ Achievable using Purview APIs plus scheduled automation
✅ Email alerts are feasible once classification changes are detected

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Sunil Kumar Pashikanti, Moderator
Blog: https://sunilpashikanti.com/posts/