Newsletter Aggregator to Weekly Digest

Overview

This flow automatically collects newsletter emails from a designated Outlook folder throughout the week and compiles them into a single, beautifully formatted HTML digest email sent every Friday morning. If no newsletters are found, it sends a brief notification instead. All configurable values are externalized as environment variables for easy tenant portability.

Trigger: Weekly Recurrence (Fridays at 8:00 AM EST)

Use Case

Many professionals subscribe to industry newsletters but struggle to keep up with them during the busy work week. This flow solves that by aggregating all newsletters into a single Friday digest, making it easy to catch up on industry news in one sitting. The digest includes the subject, sender, timestamp, and a preview snippet for each newsletter.

The flow is ideal for teams that:

• All Business Users
• Marketing Teams

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.

Configure environment variables

Set flowlibs_NewsletterFolderPath to your actual Outlook folder (e.g. Inbox/Newsletters) and flowlibs_DigestRecipientEmail to your recipient email before turning on the flow.

Create the Outlook folder or routing rule

In Outlook, create a folder or inbox rule that routes newsletter emails to the folder path you configured so the flow has something to aggregate.

Change the schedule

Edit the Recurrence trigger to run on a different day or time (e.g. Monday morning instead of Friday).

Adjust the lookback window

Update flowlibs_NewsletterLookbackDays to collect more or fewer days of newsletters.

Multiple recipients

Enter semicolon-separated emails in flowlibs_DigestRecipientEmail to fan the digest out to a team.

Customize the email template

Edit the Compose Final Digest Email action to change colors, layout, or to add a company logo to the HTML template.

Filter by sender

Add a search query parameter to GetEmailsV2 (e.g. from:newsletter@company.com) to narrow which messages count as newsletters.

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.

addDays(utcNow(), mul(-1, int(variables('varLookbackDays'))))

greaterOrEquals(item()?['receivedDateTime'], outputs('Compute_Lookback_Date'))

substring(bodyPreview, 0, min(length(bodyPreview), 300))

formatDateTime(receivedDateTime, 'MMM dd, yyyy h:mm tt')

length(body('Filter_Emails_By_Date'))