Only add record in Sharepoint if record is not in list

Hello everybody, I would love to get your help.

Short description: I want to add records to a SahrePoint list, but only if the record is not available so far.

Long description:

  • I am receiving data from Hubspot deals which contain the field “deal ID”
  • when creating a record in a SharePoint List, the “deal ID” is added as a field
  • I want to check if the “deal ID” I am currently processing is already available in the SharePoint List

Background:

  • I am getting updates from Hubspot if a Deal is updated and shifted to a specific stage (“done”).
  • unfortunately the Hupspot plugin only watches updates and my filter stage=done is true if a deal is updated after it was initially set to “done”
  • this means i would run the “add record process” multiple times