Question

Uploading CSV (Formatter) to Zapier Table (Find or Create) doesn't process individual lines

  • 15 April 2024
  • 3 replies
  • 13 views

Uploading CSV (Formatter) to Zapier Table (Find or Create) doesn't process individual lines, instead I get one line with all the values comma separated:

In this case I’m trying to find or create by Employee Number - but as you can see it just gives one long string with each of the values for that column in the file.

 

What am I doing wrong with this Zap?


3 replies

Userlevel 7
Badge +14

Hi @xdotcommer 

Try adding Looping (Create Loop from Line Items) to iterate each CSV row: https://zapier.com/apps/looping/help

Thank you.  I just started playing around with Create Loop from line items, but not sure what I should put in the two values to loop fields…

When selecting from the second drop down it still gives me Output Line Items Employee Name, with all the employee names, etc. (like the first screenshot).

 

 

 

Userlevel 7
Badge +14

@xdotcommer 

Check the field description for guidance.

Select the field that has the comma delimited list of values that you can the Zap step to loop thru. (e.g. Employee)

Help article about Looping: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

When in doubt test it out.

 

Reply