The Zap creates multiple records for new leads with the same phone number when importing.

Thanks @Troy Tessalone  :) 

This makes sense, but I still get duplicate values: 

This is my config: 

Is it correct? 

Thanks so much for helping!

You’re right @Troy Tessalone  , the test value is wrong. But the live data is correct! Thanks for checking, great idea. 

Any other hint by any chance? Can’t believe it’s not working.

Sure thing 🤓

Complete list of data in:

• table_id:

  01HAM9F50HEC25EXCPH1VPQ7TW

  filter_count:

  1

  field_data_key:

  data__f9

  operator:

  exact

  lookup_value:

  xxxxxxxxxx

  new__data__f1:

  {{205916918__fields__User First Name}}

  new__data__f2:

  {{205916918__fields__User Last Name}}

  new__data__f5:

  {{205916918__fields__User E-Mail}}

  new__data__f7:

  {{205916918__fields__User E-Mail}}

  new__data__f8:

  2023-09-27T21:34:30.816Z

  new__data__f9:

  491456543786

  new__data__f10:

  {{205916918__fields__ref}}

  new__data__f11:

  {{205916918__fields__aff}}

  new__data__f16:

  {{205916918__fields__User Street & No}}

  new__data__f17:

  {{205916918__fields__User ZIP}}

  new__data__f18:

  {{205916918__fields__User City}}

  new__data__f19:

  Ja

  new__data__f20:

  {{205916918__fields__Mandate City}}

  new__data__f21:

  golilo

  new__data__f27:

  {{205916918__fields__Unterschrift - Signature}}

  new__data__f26:

  {{205916918__fields__Mandate Date}}

  new__data__f28:

  {{205916918__fields__Unterschrift}}

  new__data__f38:

  Aboalarm

  new__data__f29:

  {{205916918__fields__Bitte nenne uns den Link zu deinem Facebook-Profil}}

  new__data__f30:

  {{205916918__fields__Nutzt du dein Facebook-Profil auch beruflich?}}

  new__data__f31:

  {{205916918__fields__Bist du vor oder nach dem 25. Mai 2018 Facebook beigetreten?}}

  new__data__f33:

  {{205916918__fields__Beschreibe, welche Art von Werbung du erhalten hast:}}

  new__data__f34:

  {{205916918__fields__War die erhöhte Belästigung vielleicht sogar ein Grund dafür, dass du deine Handynummer gewechselt hast?}}

  new__data__f32:

  {{205916918__fields__id-b190d980}}

  new__data__f35:

  {{205916918__fields__Ich werde meine Einstellungen zur Privatsphäre ändern}}

  new__data__f36:

  {{205916918__fields__Ich werde Daten von meinem Facebook-Profil löschen}}

  new__data__f37:

  {{205916918__fields__Ich werde mein Facebook-Profil löschen:}}

  new__data__f39:

  Ja

  zap_id:

  205916918

  zap_step_id:

  208478537

And data out: 

• new:

  data:f1:

  null

  f2:

  null

  f3:

  null

  f4:

  null

  f5:

  null

  f6:

  null

  f7:

  null

  f8:

  2023-09-27T21:34:30Z

  f9:

  491456543786

  f10:

  null

  f11:

  null

  f13:

  null

  f14:

  null

  f15:

  null

  f16:

  null

  f17:

  null

  f18:

  null

  f19:

  Ja

  f20:

  null

  f21:

  golilo

  f22:

  null

  f23:

  null

  f24:

  null

  f26:

  null

  f27:

  null

  f28:

  null

  f29:

  null

  f30:

  null

  f31:

  null

  f32:

  null

  f33:

  null

  f34:

  null

  f35:

  null

  f36:

  null

  f37:

  null

  f38:

  Aboalarm

  f39:

  Ja

  id:

  01HBC91BBMJZVRWD6RVDK36GTJ

  edited_at:

  2023-09-27T21:34:34.866546+00:00

  created_at:

  2023-09-27T21:34:34.868000+00:00

  schema_revision_id:

  72

  errors:

  record_id:

  01HBC91BBMJZVRWD6RVDK36GTJ

  table_id:

  01HAM9F50HEC25EXCPH1VPQ7TW

  change_id:

  01HBC91BBV9YJTKQBJ1ZS71NAD

  _zap_data_was_found:

  false

  Fields with no value:

  old

@ssielmann

Did you update this value to be the output from the Formatter step?

The crazy thing is - it all used to work a couple of hours ago :/ 

Thanks, will do!

@ssielmann 

FYI: Step 4 logic is really a find else create record

You’ll need to check the DATA OUT

That should include the Record ID.

It’s really lost: 

vs