Skip to content

// forms and surveys

Via automation

Microsoft Forms email verification with pingutil

Microsoft Forms has no webhook or code hook of its own, so email answers land in the results with no check beyond format. A Power Automate flow triggered by each new response can send the address to pingutil with the HTTP action and branch on the status, writing clean contacts to a SharePoint list, Dynamics 365 or Excel. This runs after the response is recorded, so it filters rather than blocks.

Where it connects: Power Automate flow: Microsoft Forms "When a new response is submitted" trigger, "Get response details" action, then an HTTP action

What goes wrong without it

  • Our external registration form is in Microsoft Forms and we only find the bad addresses when Outlook bounces the follow-up.
  • IT wants everything in Power Automate, not a separate server just to check emails.
  • Partners register with personal Gmail accounts and we cannot tell which company they are from.

What you can do with Microsoft Forms and pingutil

  • Route only reachable registrants to your list

    Add a Condition after the HTTP action so valid and risky responses create a SharePoint list item or Dynamics 365 contact, and invalid ones post to a Teams channel for review.

  • Tag work versus personal addresses

    Call /v1/lookup with skip_enrichment instead of /v1/verify and store category (company, free, isp) next to the response, so partner managers see who registered with a work address.

  • Fix typos before the confirmation email

    When did_you_mean comes back, send the confirmation to the suggested address only after someone approves it in a Teams adaptive card or approval step.

Set it up

  1. 1

    In Power Automate, create an automated cloud flow with the Microsoft Forms trigger "When a new response is submitted" and pick your form.

  2. 2

    Add "Get response details" with the same Form Id and the Response Id from the trigger.

  3. 3

    Add an HTTP action: POST to https://pingutil.com/v1/verify with your pingutil key in the Authorization header and the email answer in the body. Turn on Secure inputs in the action settings so the key is not shown in run history.

  4. 4

    Add a Condition on the HTTP response body status, and put your SharePoint, Dataverse or Teams actions in each branch.

  5. 5

    Configure the step after the HTTP action to also run when it fails or times out, so a pingutil error still lets the response through as unchecked.

HTTP action inputs and Condition expression
{
  "HTTP": {
    "method": "POST",
    "uri": "https://pingutil.com/v1/verify",
    "headers": {
      "Authorization": "Bearer pk_live_your_key",
      "Content-Type": "application/json"
    },
    "body": {
      "email": "@{outputs('Get_response_details')?['body/r_your_email_question_id']}"
    }
  },
  "Condition": {
    "expression": "@equals(body('HTTP')?['status'], 'invalid')",
    "if_true": "Post the response to a Teams review channel",
    "if_false": "Create the SharePoint list item or Dynamics 365 contact with status, reason and did_you_mean"
  }
}

What to do with each result

pingutil resultAction in Microsoft Forms
status: "valid"Create the contact or list item and send the confirmation.
status: "invalid"Skip the contact and post the response to a review channel.
status: "risky" or "unknown"Create the record with the status column filled, and leave it out of automated email until it is confirmed.
category: "free" or "isp" (from /v1/lookup)Mark as a personal address so it is not counted as a partner lead.

Limits to plan for

  • The HTTP action is a premium connector in Power Automate, so the flow owner needs a license that includes premium connectors.
  • Microsoft documents that the Forms connector only works with organizational accounts, and group forms need the Form Id entered by hand.
  • The flow runs after the response is stored. Respondents never see a verification error, and mailbox checks that take several seconds add to flow run time.

Microsoft Forms documentation

Microsoft Forms is a trademark of its owner. This integration uses Microsoft Forms's documented extension points; it is not an official Microsoft Forms app.

Common questions

Does Microsoft Forms have webhooks?
Not directly. The Microsoft Forms connector in Power Automate provides the "When a new response is submitted" trigger, which is the supported way to run logic on each response.
Can I do this without the premium HTTP action?
You can route the response through Zapier or Make instead, which call pingutil on their side. Either way the check happens after the response is submitted.

Stop bad addresses in Microsoft Forms today

Sign in with your email, create an API key and paste it into the step above. Test on a few real addresses first: the live demo shows exactly what your Microsoft Forms setup will receive.