I have built a Zap to identify duplicates in a Zapier table when new records are created. But in the “Find Duplicates” it identifies the “new” record that is a duplicate. Is there a way for “both” -- the new and the old duplicative records to be identified with record locator numbers?
(As I want to use both record locator numbers for future activity steps as shown below...ideally where the black line is in the second picture)
Best answer by Troy Tessalone
Post screenshots from the Zapier Table showing proof of 2 records having the same exact Address value for the Lookup Value being used to test in the Zap step config that is redacted.
Hello
I think this option of the Find Records (further down if you scroll on your screenshot) is something you can explore as it should give you all records that match the search criteria:
Then you may want to loop through the results with Looping by Zapier, or perhaps a bit more exploring to update the records found one by one, but I think this can point you in the right direction!
Remember that our amazing Support Team can provide further help here: https://zapier.com/app/get-help.
Thanks for the response,
How do I get it to return the two unique Record IDs? I don’t think that Looping would help with this, as it would still just return the one Record ID?
Hi
To get a better view, can you send us a couple of screenshots:
One with the full-set up of that Tables step setup, and one of the Table it’s searching through, showing the two duplicate records that step was supposed to find?
That’ll give us a better view of that information to see if it something we can solve here, or if it’s something you might want to reach out to our Support Team directly: https://zapier.com/app/get-help
+14
Try these Zap steps:
Thanks,
This is the “output” from the Find Records Activity. And even though there are 2 100% the same records, it is considering the duplicate only to be the “newly” added record.
I have the correct selection for multiple results, but can’t seem to get the multiple record locators to return….
+14
Post screenshots from the Zapier Table showing proof of 2 records having the same exact Address value for the Lookup Value being used to test in the Zap step config that is redacted.
I am embarrassed to say it was user error in the data. Sorry for all of the confusion due to my mistake. It now returns the 2 records.
However, as I set up the loop, I am now getting this error message when I want to update the records with “duplicate” to a specific field.
---
As background, the loop is set up correctly and outputs the two record locators:
And this is how I have the “edit” or next activity set up that its supposed to action (which prompts the error message above). What am I doing wrong?
+14
Record ID field expects a Record ID value.
Map the variable from the Looping step that has a value of the Record ID.
Make sure to take the time to review the help links for using Looping: https://zapier.com/apps/looping/integrations#help
TIP: Click field labels to see tooltips with more info about expected values and formats.
No worries, we all make mistakes, but that’s why it’s important to re-check. I’m glad the pointer to take a screenshot helped!
It doesn’t seem you have the Record ID mapped into the Record ID field, you may want to change that to the value of the Record ID that contains the long string, but choose the one that doesn’t have “Preview” at the beginning.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
