SurveyMonkey Weekly Insights Digest

Overview

This flow produces a weekly SurveyMonkey insights digest. On a schedule it reads the last seven days of survey responses, computes response volume, promoter/detractor counts and NPS, compares them to the prior week, builds an HTML report, posts the highlights to a Teams CX channel, and emails leadership — raising an alert flag when NPS falls by a configurable threshold.

Why it matters: Survey data only drives action when people see it regularly. A pushed weekly digest keeps customer sentiment front of mind and surfaces shifts early.

Status: Built and shipped Off (demo). Flow Checker 0 errors / 0 warnings. Going live requires only connection authorization and environment-variable configuration.

Use Case

A CX / leadership team wants a no-effort weekly readout of survey performance and sentiment trend, delivered to both a Teams channel and leadership inboxes, with an automatic flag when the trend moves the wrong way.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
SurveyMonkey	shared_surveymonkey	GetSurvey
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2

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.

Score source

NPS is computed from a 0-10 score carried on each response's custom_value. If your survey stores the score elsewhere (an answer in pages), adjust the four Filter-array where expressions.

Alert threshold

Change varNpsDropThreshold to make the leadership flag more or less sensitive.

Cadence / window

Change the Recurrence schedule and the addDays(...,-7/-14) window starts together.

Per-segment

Duplicate the flow per product/region with a different flowlibs_SurveyId.

Power BI link

Add a link in the HTML report to a full NPS dashboard.

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.

@if(greater(length(thisData),0), sub(div(mul(length(promoters),100),length(thisData)), div(mul(length(detractors),100),length(thisData))), 0)

@greaterOrEquals(int(coalesce(item()?['custom_value'],'0')),9)

@and(greater(int(coalesce(item()?['custom_value'],'0')),0),lessOrEquals(int(coalesce(item()?['custom_value'],'0')),6))

@if(less(npsThisWeek,npsLastWeek),'DOWN','UP')

@if(greaterOrEquals(sub(npsLastWeek,npsThisWeek),variables('varNpsDropThreshold')),'YES','NO')

@{formatDateTime(addDays(utcNow(),-7),'yyyy-MM-ddTHH:mm:ss')}

Customize & download