Many IT operations teams manually process scheduled ServiceNow incident report CSV attachments and copy details into Microsoft Teams. You can streamline this using Microsoft Power Automate to turn scheduled email attachments into an automated alerting pipeline without heavy direct API integrations.
🏗️ The System Architecture
The workflow uses the scheduled email as a lightweight event source:
ServiceNow Scheduled Report/Any Scheduled report with in CSV Format ──► Outlook Email ──► Power Automate (CSV Parser) ──► Teams Alert
🛠️ Implementation Summary
- The Trigger: Use Outlook's When a new email arrives (V3) with a strict subject filter and attachments enabled.
-
Validate & Convert: Loop through attachments, filter for
.csv, and convert base64 content bytes to text strings. - Normalize & Split: Clean up Windows-style line breaks and split rows into an array.
- Extract & Filter: Skip header rows, parse column indexes, and apply priority conditions (e.g., High/Critical) before pushing alerts to Microsoft Teams.
⚠ Crucial Production Constraints
- Simple Split Delimiters: Assumes no internal commas within quoted text fields.
- Layout Alignment: Zero-based array indexes must be updated if ServiceNow modifies the report layout.
📖 Looking for the Full Code Expressions?
To view complete workflow diagrams, detailed regex cleanup strings, or alternative layouts, you can find the full content in the referenced web document:
👉 Read the Complete ServiceNow to Teams Power Automate Tutorial
Top comments (0)