From Pocket to Airtable

[Edward_shamosh]

From Pocket to Airtable

• I want this flow to update every hour or so.
• I’m trying to create a flow when I add a article to pocket it triggers aa flow to add or update on Airtable to remind me to review it for blog ideas.
• I’ve tried upsert that didn’t work so I’m trying to filter if record not created add record. If already created, update info.

Issue

• The first time I run it it works fine but when I run it a second time it is creating duplicate records by default it should be able to match records
• I know there should probably be more nodes please help me by ether providing me a simpler flow or one that works better.

Blueprint File

blueprint.json (40.4 KB)

Flow Images

[Msquare_Automation]

Hi @Edward_shamosh

Please use search module to find exiting record with required value.
eg:

out:

Include filter for exist and not exist.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

[Edward_shamosh]

thank you for your response.

I needed to search pocket not airtable, pocket is the source data I also need you to provide context for what is quarterly launch

so what happens if there are more than one record let’s say there’s five records? will this flow be able to update all five or create five new ones?

[AutoPilots]

Hi @Edward_shamosh,

In your current settings, you have a limit on the search module of 10 items, but you don’t have a filter IN the search module to limit which items Airtable will output. Therefore the output only contains the (first) 10 items. If these are not the ones you get from Pocket, you will create a new item in Airtable.

You can solve this in 2 ways:

1. Set the limit to a high amount so the search module will check the complete base.

2. Define the search criteria in the “formula” field in the search module of Airtable (this would be my preference, and is also the suggestion of @Msquare_Automation). This filter ensures the module only outputs the records from Airtable that meet your filter criteria (i.e. your pocket item). Make sure to also set the limit in line with the amount of items you expect from Airtable.
   Next you can use the filter to check if the search module has found a record in airtable. If no record exists, you create a new record. You can use the filter as suggested before, or use the following:
   

   

If records are found you continue on the second path. All records found will be updated. Filter:

Good luck.