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.

I'm trying to split text to multiple items that I can use in different fields in another step. It works fine for names but not email addresses for some reason.
 

I tried this and it worked for a simple array of Full Names - https://community.zapier.com/ask-the-community-3/line-item-usage-358 - but I get a different output structure for email addresses. 

From an Airtable record with a lookup array of Names mJane Smith, John Smith] it returns:
output__Item 1: Jane Smith

output__Item 2: John Smith

which is exactly what what I want it to return.

Unfortunately, when I try the same formatting steps for email addresses in an array I get the following output where the item numbers are the same:

output:
0:

   Item 1: janesmith@email.com

1:

   Item 1: johnsmith@email.com

The problem is the are the same Item number so when I try to use them as inputs later on in the workflow as separte fields, the only selection I can use from this step is 'Output Item 1: "janesmith@email.com, johnsmith@email.com"' (an array, not separate items). 

Any thoughts?

Hi @CourtneyBaker!

 

The way that the email addresses are formatted in the output makes me think that they are a nested array (an array within an array), which is likely why the step isn’t working. 

 

One fix for this would be to address the source (see if there’s something that you can change in Airtable that will change the way the data is stored/sent). I’m not sure how possible that one is. 

 

The option for fixing this with Zapier would be to use some more Formatter steps. First you’ll need to use Formatter > Utilities > Line item to text. That will take the item array and convert it into a single text string separated by commas. If you then need to change this back into a single array (rather than a nested array) then you’ll need another Formatter step, this time using the ‘Text to Line item’ transform, which will convert the string into a regular line item array. 

Terms & Conditions