I wanted to create a scenario where incoming mails first get filtered by a list of emails in Airtable. This works fine.
Then, the scenario should check whether the email address already exists in another Airtable (“email tabel”) or not. If it doesn’t exist, it should create a record with this email address and the body of the email.
If it does already exist, it should only update the body of the email by adding the new content.
This is where the scenario is behaving strangely. When testing it with new emails, it does create new records (as it should, because it does not find the email address in Airtable). But when I then try to update the records by sending another email with the same address, it starts doing strange things, like creating new records or both updating and creating new records at the same time.
In the last two pictures, you can see that it is not updating properly in Airtable.
Does anybody have any idea what I am doing wrong here? Any feedback is welcome! Thanks a lot in advance.
