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]