Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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

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.

can we do a remote sessie 

@jweroen 

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

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 

@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.

 

@jweroen 

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

 

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

 

 

 

@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?

 

@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/

table lookup works perfect 

Data in test flow lok oke

 

 

No data in field om mailchimp 

 

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  

 

@jweroen 

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

 

 

 

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

 

do you have a example how to fix this issue 

@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

 

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

 

 

@jweroen 

Did you try this?

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

Formatter > Utilities > Text to Line Items

I did but still the same problem Troy

 

@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

Terms & Conditions