Work · National food brokerage · 2024
Employee SMS broadcast platform
Microsoft Forms Power Automate Microsoft Graph Twilio Cloudflare Worker Dynamic Entra ID groups
Skills exercised
Production SMS broadcast platform for authorized employee communications company-wide. Designed to make a broadcast as easy as filling in a Microsoft Form, with approval routing and audience targeting handled downstream.
Pipeline
- Sender fills in a Microsoft Form with the message, audience, and (when needed) an approver.
- Power Automate picks up the submission and routes through Teams or email approval if required.
- Audience is resolved against dynamic Entra ID groups (All Employees, by region, by division) via the Microsoft Graph.
- Twilio sends the SMS over a toll-free A2P verified number.
- STOP and HELP are handled via Twilio Advanced Opt-Out per CTIA Short Code Monitoring Handbook standards.
Audience targeting
Maps to dynamic Entra ID groups that automatically include the right employees based on attributes. Recipients can be filtered to all employees, by region, or by business division.
Compliance
- Twilio toll-free verification approved for A2P compliance.
- STOP and HELP keywords handled via Twilio Advanced Opt-Out, conforming to CTIA standards.
- A public-facing Terms & Conditions page deployed alongside the platform on a company-owned domain.
Cost shape
Roughly $8 per blast for 1,000 employees at toll-free SMS pricing. The Worker repo is laid out for the Cloudflare Worker, the public docs, the SMS signup flow, and the Terms & Conditions page.