Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Contacts not syncing to Mailchimip

(1) ShareShare
ReportReport
Posted on by 6
I am trying to push contacts to a MailChimp list. My List rows and associated filters work perfectly. The output data from List Rows is 100% correct, with just the 4 fields I need (first name, last name, email, and last visit date). The iteration For each is failing because of MailChimp but the INPUTS for the MailChimp connector look good. I am not sure why this isn't working.
 
  • creativeopinion Profile Picture
    creativeopinion 10,056 on at
    Contacts not syncing to Mailchimip
    The error you are getting is due to the fact that Mailchimp will only allow you to add an email address to a list (audience) once. If the email address already exists you will need to use the Update Member Information action instead of the Add Members to List Action.
     
    I would recommend using the Show list members action to get the members from the list and run a cross-check with those email addresses you are trying to add/update. Use the Filter Array action to cross-check the email addresses. Filter out those that need to be added and those that need to be updated.
     
    If you aren't sure how to use the Filter Array action, you may be interested in these YT Tutorials:
     
    Are you using the Microsoft Power Automate Filter Array Action wrong?

    In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.
    1️⃣ Cross-Referencing Data
    2️⃣ Filtering by Key
    3️⃣ Substring Matching

    Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

    IN THIS VIDEO:
    ✓ 3 Ways to Use the Filter Array Action
    ✓ How to use the Scope Action to Group Actions
    ✓ How to Check the Number of Items returned from a Filter Array Action
    ✓ How to Cross-Reference Data in Excel with a SharePoint List
    ✓ How the Filter Array Action Works
    ✓ How to Access the Dynamic Content from a Filter Array Action
    ✓ How to Filter Items by a Key
    ✓ How to Filter Items by Matching a Substring
    ✓ How to Use Multiple Conditions in a Filter Array Action

    ---

    In this tutorial—I’m going to show you a quicker way to get the dynamic content from your Filter Array action—and it doesn’t require writing an expression.

    IN THIS VIDEO:
    ✓ How to Loop Through Filter Array Results in Power Automate
    ✓ Using Apply to Each with Filtered Arrays
    ✓ The Easiest Way to Access Dynamic Content from Filter Array
    ✓ Fixing Nested Apply to Each Actions
    ✓ When to Use Value vs. Body Dynamic Content
    ✓ Simplifying Power Automate Flows with Filter Array
    ✓ Troubleshooting Filter Array and Apply to Each Issues
     
     
    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • AS-13011808-0 Profile Picture
    AS-13011808-0 6 on at
    Contacts not syncing to Mailchimip
    Thank you, Tom.  I am using the Mailchimp connector inside the flow so the API from MailChimp is automatically used inside the flow. I get this error from the MailChimp output: "emailxxxxxx.com is already a list member. Use PUT to insert or update list members." I do not know what this means as the list is empty. Oddly, if I remove the filters, then contacts are added and the flow completes. But I need the few filters I have in place, to go through.
  • trice602 Profile Picture
    trice602 11,627 on at
    Contacts not syncing to Mailchimip
    Hi,
     
    The most likely root cause are permissions.  Check this out.  
     

    Verify MailChimp Permissions

    • Ensure the API key used in the MailChimp connector has the necessary permissions to:
      • Access the audience.
      • Add or update contacts.
    • You can generate or verify the API key in MailChimp under Account SettingsExtrasAPI Keys.
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard