Twilio Lead Speed-to-Contact SMS

Overview

This flow capitalizes on the speed-to-lead window using Twilio SMS, Dataverse, and Microsoft Teams. When a new lead row is created in Dataverse, the flow instantly texts the lead a personalized greeting, picks the next available rep via round-robin (least-loaded first), logs the touch on the lead, rebalances the rep's load, and alerts the sales channel in Teams with full lead context. If no rep is available, it raises a no-rep alert so the lead still gets a fast manual follow-up.

Why it matters: Conversion drops sharply with response delay. An immediate, personal text plus instant rep assignment captures interest while it's hot — far faster than a human can react. Built API-first, ships Off; going live needs only connection auth + env var values.

Use Case

A sales team wants every new lead contacted within seconds by SMS and routed to a rep, so no lead goes cold waiting for someone to notice. Reps are kept balanced by a round-robin that always picks the least-loaded available rep.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Twilio	shared_twilio	SendMessage
Microsoft Dataverse	shared_commondataserviceforapps	SubscribeWebhookTrigger ListRecords UpdateRecord
Microsoft Teams	shared_teams	PostMessageToConversation

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.

Rep pool

Populate flowlibs_salesrep rows; set flowlibs_availability to Available/Busy. The flow auto-picks the least-loaded available rep.

Business hours

Wrap the SMS step in a condition that queues greetings sent outside hours for the next opening.

Territory routing

Replace the $orderby assignedcount asc round-robin with a $filter on region/product to assign by territory.

Greeting copy

Edit varCompanyName or the Send_Welcome_SMS body template.

Inbound replies

Add a Twilio inbound-SMS webhook flow that matches the sender against the lead's assigned rep and forwards the reply (separate flow; not included in this Off demo).

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.

@first(body('List_Available_Reps')?['value'])

@greater(length(coalesce(body('List_Available_Reps')?['value'], createArray())), 0)

@concat('Hi ', coalesce(triggerOutputs()?['body/flowlibs_name'],'there'), '! Thanks for reaching out to ', variables('varCompanyName'), '. ', coalesce(outputs('Compose_Selected_Rep')?['flowlibs_name'],'A team member'), ' will contact you within minutes. Reply STOP to opt out.')

@add(coalesce(outputs('Compose_Selected_Rep')?['flowlibs_assignedcount'],0),1)

Customize & download