Microsoft Teams Alerts Configuration
Collate integrates with Microsoft Teams using Workflow Webhooks to deliver alert messages directly to your Teams channels. This allows you to receive real-time notifications within Microsoft Teams.Important Migration Notice
Microsoft Deprecation Update: Microsoft has deprecated the legacy Office 365 Connector approach in favor of Workflow Webhooks.If you are using Collate v1.11.0 or later:
- ✅ No code changes are required
- ✅ Collate already sends Adaptive Cards format
- ⚠️ Action Required: If you previously saved an Office 365 Connector URL, you must replace it with a new Workflow Webhook URL
Setting Up a Microsoft Teams Workflow Webhook
An incoming webhook allows Collate to share alert content directly in your Teams channels and chats. Follow these steps using Microsoft’s pre-configured webhook templates.Step 1: Access Workflows from Your Channel
- In Microsoft Teams, navigate to the channel or chat where you want alerts to be posted
- Click More options (…) next to the channel or chat name
- Select Workflows
Step 2: Select the Webhook Template
Microsoft provides pre-configured webhook templates. Search and select the “Send webhook alerts to a channel” pre-configured Webhook template to continue.Step 3: Name and Configure the Webhook
- Enter a Name for the workflow (e.g., “Collate Alerts”)
- Optionally, add a Description (e.g., “Receives data quality and governance alerts from Collate”)
- Review the authentication settings (the defaults are typically fine)
- If you need to use a different account to post messages, click Switch account
- Click Next
Step 4: Select the Destination
- The workflow will ask you to specify where to post messages
- Select your Team, Channel, or Chat (these fields auto-populate if you started from a specific channel)
- Verify the account authentication is correct
- Click Add workflow to create the workflow
Step 5: Copy Your Webhook URL
- A confirmation dialog will appear displaying your HTTP POST URL
- Copy the complete URL exactly as shown (do not modify or truncate it)
- Store this URL securely - you’ll paste it into Collate next
Finding Your Webhook URL Later
If you need to retrieve your webhook URL again:- Open the Workflows app in Microsoft Teams
- Find and select your Collate workflow
- Click Edit
- Expand When a Teams webhook request is received
- Copy the HTTP POST URL displayed there
Configuring Microsoft Teams Webhooks in Collate
Once you have your Workflow Webhook URL, follow these steps to configure it in Collate:Step 1: Access Alert Configuration
- In Collate, navigate to Alerts & Notifications from the main menu
- Select the type of alert you want to configure:
- Data Observability Alerts (for data quality and pipeline monitoring)
- System & Governance Notifications (for metadata and governance events)
Step 2: Add Microsoft Teams as a Destination
- Click Add Destination
- Select Microsoft Teams from the available destination options
- Paste your Workflow Webhook HTTP POST URL into the MS Teams Destination (HTTP POST URL) field
- Optionally, enter a Display Name for this Teams destination (e.g., “Data Quality Alerts”)
Step 3: Test the Connection
- Click Test Connection to verify the webhook is working
- A test message will be sent to your Teams channel
- If successful, you’ll see a confirmation message and the test message will appear in your Teams channel as an Adaptive Card
Step 4: Save and Enable
- Click Save to store the configuration
- The Microsoft Teams destination is now ready to receive alerts
Best Practices
- Dedicated Channels: Create separate Teams channels for different types of alerts (e.g., #data-quality-alerts, #pipeline-failures, #governance-events)
- Channel Members: Ensure all relevant team members are added to the Teams channel
- Multiple Webhooks: You can configure multiple Workflow Webhooks to send different alert types to different channels
- Workflow Testing: Always test your Workflow webhook in a non-production channel first
- Notifications: Enable notifications for the channel so team members don’t miss important alerts
Migration Guide: From Office 365 Connector to Workflow Webhook
If you’re currently using the legacy Office 365 Connector URLs:- Create a new Workflow Webhook following the setup steps above
- Copy the new Webhook URL from the Workflow
- Update Collate with the new Workflow Webhook URL
- Test the configuration in a test channel first
- Delete the old Office 365 Connector from Microsoft Teams once the new Workflow is working