File Alert Demo

Overview

This demo flow watches a configured SharePoint document library, reads the new file's properties when an item is created, and posts a notification to a Microsoft Teams channel so the relevant team sees new uploads in near-real-time. It's a minimal, reliable "SharePoint → Teams" alert pattern — the simplest building block for a fan-out alerts library.

Use Case

Teams that collaborate on documents in SharePoint typically don't camp on the library — they live in Teams. Email subscriptions are noisy and easily ignored. This flow keeps the team in the loop where they already work: a clean Teams channel post every time someone drops a file in a watched library, complete with the file's metadata.

The flow is ideal for teams that:

• Real-time visibility — files in the library show up in Teams within seconds.
• Site URL, library name, channel, and group all configurable via env vars.
• Minimal action count keeps run-time costs low.
• Works as a teaching pattern for the wider FlowLibs alerts collection.

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.

Promote SharePoint to a connection reference

Add a SharePoint connection reference to the solution and re-bind the trigger + Get file properties — required for clean ALM.

Filter by file type or naming pattern

Add a Condition after Get file properties that gates the Teams post on endsWith(triggerOutputs()?['body/{Name}'], '.pdf') or a regex on the filename.

Switch to adaptive cards

Replace Post message in a chat or channel with Post adaptive card in a chat or channel for richer formatting (thumbnail, 'Open file' button).

Email fallback

Add an Office 365 Outlook Send Email (V2) after the Teams post to also notify a distribution list.

Group multiple files into a digest

Replace the SharePoint trigger with Recurrence + Get files (properties only) filtered by Modified ge addDays(utcNow(), -1) and post a daily digest.

Promote the message template to an env var

Move the Teams card body into a string env var so wording can change without flow edits.

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.

parameters('flowlibs_SharePointSiteURL')

parameters('flowlibs_FileAlertsLibraryName')

outputs('Get_file_properties_-_Get_New_File_Details')?['body/{FilenameWithExtension}']

outputs('Get_file_properties_-_Get_New_File_Details')?['body/{Link}']