cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

HOWTO: MailChimp Webhook

Admins: Feel free to move to the appropriate place but I struggled to find any documentation to get this integration working and thought I'd document it myself

MailChimp supports triggers of "When A Member Has Been Added To A List" & "When A New List Is Created"; for anything else you need to use a webhook.

While MailChimp has documentation here, it misses one important step to get it working with Power Automate; and that is that when you save your configuration in MailChimp it performs a GET request to check the validity of the URL you've provided. After this it only uses POST. 

To set this up with Power Automate first create a trigger using "When a HTTP request is received" and under Show Advanced Options set the Method to GET. 
When An HTTP Request is received.png
Add an Action "Initialize Variable", set its Type to Object and Value to "Body" of the trigger "When an HTTP request is received"

InitializeVariable.png
At this point you can save the Flow and a URL is generated in the initial trigger... 
Grab URL.png
Copy this URL and head on over to your MailChimp dashboard.

Select your Audience and in the dropdown on the right hand side go to Settings.

Down the bottom select Webhooks, and Create New Webhook.

Paste the copied URL from above into the "Callback URL" field, select what Updates you want, and hit Save.  

At this point you can return to your flow and remove GET from the Method under Show Advanced Options and you should be able to test it out.


Just keep in mind that if you go to modify the MailChimp webhook at any time you'll have to set the method back to GET temporarily while MailChimp verifies the supplied URL again.

 

I then grab the email address from the provided $formdata using...

GrabEmailAddress.png

Hope this helps someone.

2 REPLIES 2
Highlighted
Resolver III
Resolver III

Re: HOWTO: MailChimp Webhook

This is a helpful tutorial, and it all works for me up to a point. When I add another connection to the flow (such as SharePoint, though I've replicated the same behavior with several different connectors), it breaks the flow's trigger the next time I receive a call from the MailChimp webhook.  The call itself doesn't even show up in the run history.

 

I've done a number of tests and it seems like this behavior is related to MailChimp sending the call with the 'x-www-form-urlencoded' content type.  If I call the same flow from another service (such as Postman) using the 'application/json' content type, the flow still works fine.

 

The strange thing is that as long as the flow has no other connections, it seems to handle the form data just fine.  I can select the variables that I want, parse the form data as JSON - anything at all, as long as it only uses built-in functions.  As soon as I try to connect to a SharePoint list to save the data, the flow stops working.

 

I'd appreciate fixes if people have them, but even knowing if this is impacting other people would be helpful.

Highlighted
Frequent Visitor

Re: HOWTO: MailChimp Webhook

Sounds odd as mine runs perfectly with connections to both Dynamics 365 and Teams.

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Kudoed Authors
Users online (6,557)