Google Drive New File to Teams Notification

Overview

This flow keeps a team instantly aware of new or updated content in a watched Google Drive folder. On a schedule it lists the folder, detects files it has not seen before (de-duplicated via a Dataverse ledger), posts a formatted card-style message to a Microsoft Teams channel with the file name, type, owner, modified date, and a Drive link, and optionally emails a reviewer via Outlook.

Why it matters: New Drive files go unnoticed. Surfacing them in Teams (where the team already works), with a one-click link, removes the "did anyone see this?" gap.

Status: Built as solution FlowLibs - Google Drive New File to Teams Notification (CF-682). Ships Off - go-live requires only connection authorization and environment-variable values.

Use Case

A team collaborating around a shared Google Drive folder (marketing assets, operations docs, intake) wants a Teams heads-up whenever a file lands or changes, plus an optional email to a named reviewer.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Google Drive	shared_googledrive	ListFolder
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2
Microsoft Dataverse	shared_commondataserviceforapps	ListRecords CreateRecord

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.

Type filter

Add a Condition on MediaType (or filename extension) to notify only on certain file types.

Mention routing

Map folders to reviewers by extending flowlibs_ReviewerEmail into a lookup, or add multiple recipients.

Polling cadence

Change the Recurrence interval (default Minute / 5) to suit latency vs. API-call budget.

Digest mode

Accumulate matches and post one periodic summary instead of per-file messages.

Updates vs. new only

The ledger keys on file id + last-modified, so edited files re-notify. To notify on new files only, key the dedup on flowlibs_fileid alone.

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.

@equals(items('Apply_to_each_File')?['IsFolder'], false)

@concat('flowlibs_fileid eq ''', items('Apply_to_each_File')?['Id'], ''' and flowlibs_lastmodified eq ''', items('Apply_to_each_File')?['LastModified'], '''')

@equals(length(outputs('Check_Ledger_For_File')?['body/value']), 0)

@concat('https://drive.google.com/file/d/', items('Apply_to_each_File')?['Id'], '/view')

@not(equals(variables('varReviewerEmail'), ''))

Customize & download