Hello ​@ashland 

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, ​@Marley. Yes, I already had that selected when you scrolled down but it only returns ONE Record ID. There is an “Results Old ID” but it is still the same Record Locator Number.

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 ​@ashland 

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

​@ashland 

Try these Zap steps: 

1. Trigger: Tables - New Record
2. Action: Tables - Find Records
3. Action: Filter
   1. Check to make sure there are records returned to process
   2. Count > 0
4. Action: Looping - Create Loop from Line Items
   1. Help: https://zapier.com/apps/looping/help
5. Action: Tables - Update Record
   1. Map the Record ID from Step 4

Thanks, ​@Troy Tessalone  -- very helpful! I think the Looping makes sense to update BOTH records. However, I am struggling to get both records to actually come back as results. 

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….

​@ashland 

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?

​@ashland 

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.

​@ashland 

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.