Stripe Failed Payment Dunning Workflow

Overview

The Stripe Failed Payment Dunning Workflow runs an automated, event-driven dunning (failed-payment recovery) process on top of Stripe. It is delivered as two cloud flows + one Dataverse ledger table in a single solution: 1. Receiver — a real-time HTTP webhook that Stripe calls on invoice.payment_failed / charge.failed. It looks up the Stripe customer, opens a dunning ledger record, and sends the customer the first branded recovery email containing the Stripe hosted-invoice retry link. 2. Retry Sweep — a daily scheduled flow that walks the open ledger records, re-checks Stripe to see if the invoice was paid, sends staged reminders on a configurable cadence (default day 1 / 3 / 7), marks recovered invoices, and escalates exhausted cases to the account manager as churn risk. A shared correlationId is minted in the receiver and stamped on the ledger row so the entire recovery lifecycle is traceable across both flows. Why it matters: Involuntary churn from expired cards and transient declines is recoverable revenue. A polite, staged dunning sequence with a one-click retry link recovers a large share of failed payments automatically, and only pulls a human in once automation is exhausted.

Use Case

A subscription business wants failed payments handled gracefully: the customer gets a clear, branded nudge with an easy one-click fix; finance keeps a complete ledger of failures, attempts and outcomes; and account managers are only engaged when automated recovery has run its full course. The split between a webhook receiver (real-time first contact) and a scheduled sweep (staged follow-ups) avoids long-running flows with multi-day Delay actions and makes the retry cadence fully data-driven.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Stripe	shared_stripe	GetCustomer
HHTTP	http	GET /v1/invoices/{id}
Microsoft Dataverse	shared_commondataserviceforapps	ListRecords CreateRecord UpdateRecord
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.

Retry cadence

Edit flowlibs_RetryCadenceDays (e.g. 1,3,5,7,10); the number of entries automatically becomes the number of follow-up reminders before escalation, no flow edits needed.

Let Stripe drive timing

Alternatively, enable Stripe Billing's own Smart Retries and reduce this solution to comms + logging only.

Dunning tone

Escalate the email copy across stages (friendly to firm to final notice); the staged email already shows 'reminder X of Y'.

Escalation routing

Point flowlibs_AccountManagerEmail at a shared mailbox or per-segment owner.

Signature verification

Add an inline HMAC-SHA256 check of Stripe-Signature before processing (see Auth note).

Going live

Authorize the three connections, set env var values, register the Stripe webhook, and turn both flows On.

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.

@{outputs('Compose_Invoice_Fields')?['hostedUrl']}

@addDays(utcNow(), int(first(split(variables('varRetryCadence'),','))))

@addDays(coalesce(items('For_Each_Due_Record')?['flowlibs_firstfailuredate'], utcNow()), int(first(skip(split(variables('varRetryCadence'),','), int(coalesce(items('For_Each_Due_Record')?['flowlibs_attemptcount'],1))))))

@greaterOrEquals(int(coalesce(items('For_Each_Due_Record')?['flowlibs_attemptcount'],1)), variables('varCadenceCount'))

@or(equals(toLower(coalesce(body('Get_Invoice_Status')?['status'],'')),'paid'), equals(coalesce(body('Get_Invoice_Status')?['paid'],false),true))

Customize & download