About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How do I send picklist values instead of IDs to Mailchimp?

  • 31 January 2024
  • 41 replies
  • 172 views
J
Badge

how can i send the picklist value instead of the id to mailchimp 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

41 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @jweroen 

For us to have more context, please post screenshots with how your Zap steps are outlined and configured along with which values and fields you are having issues with.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

can we do a remote sessie 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

If you need 1:1 help, consider hiring a Certified Zapier Expert: https://zapier.com/experts

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

i see the piclist id instead of value in mailchimp from crm

How can we fix this 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

For us to have more context, please post screenshots with how your Zap steps are outlined and configured along with which values and fields you are having issues with.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

You may need to use the concept of a lookup table to translate the values from the IDs to the labels.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

I did do a lookup table but now i get nothing in the field from mailchimp

 

 

J
Badge

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

Can you show screenshots with how that MERGE field is configured in Mailchimp so we can see the type of field that it is?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

Try turning the Zap ON and doing a live test.

Then check your Zap Runs history details to see the DATA IN/OUT for each Zap step to help you troubleshoot.

https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

table lookup works perfect 

Data in test flow lok oke

 

 

No data in field om mailchimp 

J
Badge

 

The problem is only with  a multi-select picklist, when you select more then one value in the list

With one value selected there is no issue  

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

Post updated screenshots with how your Zap step 3 is configured.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

 

J
Badge

 

J
Badge

this one is only showing the first selected item in the picklist

 

J
Badge

do you have a example how to fix this issue 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

Can you show the output from testing the Formatter step with 2 values?

You may need to convert the values to an array of items.

Formatter > Utilities > Text to Line Items

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

the output is empty with a multi select that is the problem 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

Did you try this?

You may need to convert the values to an array of items.

Formatter > Utilities > Text to Line Items

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Badge

I did but still the same problem Troy

J
Badge

 

Troy Tessalone
Userlevel 7
Badge +14

@jweroen 

This would come before the Formatter > Utilities > Lookup Table step.

 

You may need to convert the values to an array of items.

Formatter > Utilities > Text to Line Items

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions