Send form submissions to Microsoft Teams

SagePigeon posts each website form submission into a Teams channel as a card. The card lists every answer, and an Open in SagePigeon action takes you to the full record. Teams delivery is on the Pro and Scale plans.

What the card shows

For a form called "Quote request", the card reads:

Example
New submission: Quote request

Name          Priya Raman
Company       Harbour Clinic
Work email    priya@example.com
Budget        £5,000–£10,000
What do you need?   A booking form for three clinics

[ Open in SagePigeon ]

Each answer is a name and value pair (Teams calls these facts). The names come from your field names: work_email becomes "Work email". Up to 20 answers are shown, and a value longer than 400 characters is cut with "…". The card's summary line, which Teams uses in the activity feed, is "New submission on Quote request".

SagePigeon sends a MessageCard, the card format that Teams' classic incoming webhooks accept:

JSON
{
  "@type": "MessageCard",
  "@context": "https://schema.org/extensions",
  "themeColor": "1F3FD8",
  "summary": "New submission on Quote request",
  "title": "New submission: Quote request",
  "sections": [{ "facts": [{ "name": "Name", "value": "Priya Raman" }], "markdown": false }],
  "potentialAction": [{ "@type": "OpenUri", "name": "Open in SagePigeon", "targets": [{ "os": "default", "uri": "https://…/app/forms/FORM_ID" }] }]
}

Set it up

  1. In Teams, create an incoming webhook for the channel and copy its URL.
  2. In SagePigeon, open the form, go to Settings, then Integrations.
  3. Under Chat destinations, press Add a destination and choose Teams from the type list.
  4. Paste the URL, keep on ticked, and press Save integrations.
  5. On the Setup tab, press Send a test submission and check the channel.

Plans

Pro ($49 a month) and Scale ($149 a month). On Free, Teams shows as "paid" in the type list and the server refuses to save it. If a workspace moves back to Free, Teams destinations stay configured but stop posting until it upgrades again. See pricing.

Limits and gotchas

  • Test with a real submission first. Microsoft has been moving Teams from Office 365 connectors to Workflows, and the kinds of webhook URL a tenant can create depend on its admin settings. Send a test submission and confirm the card appears before you rely on it. If it does not, the form's delivery log shows the status Teams returned.
  • https and a public address only. Private network addresses are refused when you save and again before each post.
  • 10 seconds, then retries. A post that is refused or takes longer is tried again after 30 seconds, 2 minutes, 10 minutes and 15 minutes, and each attempt is in the delivery log. The email notification is unaffected. A card format Teams will not accept fails all 5 times, which is another reason to send that test first.
  • Up to 10 destinations per form, so one form can post to Teams and Slack at once.

Teams is on Pro.

See pricing, or start free and upgrade from Billing when you are ready.