Excel → Trello Checklist via Zapier is splitting line items incorrectly

Hi ​@JTHOM6 

For us to have more context, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

Hi ​@Troy Tessalone! Please see attached
 

​@JTHOM6 

Zap step 2 is configured to already return results as line items.

So you should not need Zap step 3 (Formatter), so remove that step.

Instead, map the data from Zap step 2 to the Looping (Create Loop from Line Items) step.

​@Troy Tessalone  I removed the Formatter step. I mapped the line items from Step 2 directly into the Looping step. Does this look right? Also, in the Create Card step, what data should  I click?

​@JTHOM6 

Actually, you don’t need the Looping step, so you can remove the Looping step.

Trello Card field “Checklist Items” supports line items.

So map the data from Zap step 2 (Excel) to the Trello Card step.

Thanks, Troy, for the continued support. From the dropdown, which option should I choose? For example, if I select Item_SNID and Item_Description, they show up in Trello as separate lists like “SNID1, SNID2, SNID3” and “D1, D2, D3,” instead of being paired as “SNID1 – D1, SNID2 – D2, SNID3 – D3.”

​@JTHOM6 

Map both variables in the same input field: [SNID] - [Description]

Hey ​@JTHOM6 👋 Have you had a chance to try Troy’s suggestion of adding both the Item_SNID and Item_Description fields into the same Checklist Item field yet?

Let us know if that does the trick, or if you could do with some more help!

​@JTHOM6 

Good to know.

That’s great ​@JTHOM6! Thanks so much for sharing how you solved it 🤗 I’ll get that marked as the Best Answer to help surface it to others that might be looking to do something similar. 

And thank you for jumping in to help out here ​@Troy Tessalone, always appreciated! 🧡