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

table lookup works perfect 

Data in test flow lok oke

No data in field om mailchimp 

Hi @jweroen! 👋

Hope you don’t mind me jumping in to lend a hand here. From the latest screenshot, it looks as though step 2. of the Zap is the Formatter (Utilities > Lookup Table) action, is that correct? 

If so, you’ll want to move that Formatter action down so that the Formatter (Utilities > Text to Line-items) action runs first):


Then step 3. of the Zap should be the Formatter action that has the lookup table. And in there the input would be what’s being output by the previous Formatter action that coverts the text into line-items. 

That way the Zap will trigger when there’s a new contact created and convert the comma separated list of IDs in the Aci Testmulti field into line-items. Then pass those line-items into the lookup table and output the relevant names for each to be used in the Mailchimp action.

If I’ve misunderstood or if you run into any issues on that just let us know, happy to help further! 🙂 

i did the steps above but then we get no data in the mailchimp field

can we do a remote session because i need to fix this for a demo monday 

It is working now

a customer of us will have this product do you the prices of this product

We are the dynamics 365 partner

can we do a remote sessie 

@jweroen 

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

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

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