Airtable reader not reading the row with search value

[Radvin18tid]

This is the workbook link: https://www.gumloop.com/pipeline?workbook_id=nPeQ49jcXnxrRgDHq1uVJL&tab=6&run_id=gbKPYQQND8r3Yy743xZgkC

run link: https://www.gumloop.com/pipeline?run_id=gbKPYQQND8r3Yy743xZgkC&workbook_id=nPeQ49jcXnxrRgDHq1uVJL&tab=6

I was searching for a value “test123” in the lookup column of the airtable : Airtable

It is inavriably returning an empty row. I have been trying to resolve this for quite some time.
Could you please help me out with this ?
Thanks

[Gumloop_Bot]

Hey @Radvin18tid! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Wasay-Gumloop]

Hey @Radvin18tid – I’m assuming here that the search value does exist in your Airtable base in the column FolderName as specified, do you mind sharing a screenshot from your Airtable base or deleting and adding back the Airtable Reader node please?

Currently, what’s happening is that the search value is not found in the search column and the node hence throws an error and continues down the error path:

[Radvin18tid]

Yes it is definitely there.
My end goal was to create folders in google drive and prevent the creation of duplicate folders. if the folder name is present in the airtable:
then create folder
else:
continue with the flow
However, the airtable reader is not finding the search term.
I have tried a lot of things, this is really not working.

[Wasay-Gumloop]

Thank you for sharing this @Radvin18tid, this is definitely odd.

Couple notes:

1. Can you try deleting and adding back the ‘Airtable Reader’ node please?
2. If you try with a different search value (folder name), does it still throw an error?
3. Would you mind running the Airtable Reader without any search value in a separate flow and sharing the run link please?

Really appreciate your cooperation here!

[Radvin18tid]

I had tried deleting the Airtable Reader node. That did not work.
Here is the workbook link you had requested:
https://www.gumloop.com/pipeline?workbook_id=nPeQ49jcXnxrRgDHq1uVJL&tab=11&run_id=Foeo8i33aNEdznf8A2Xp7C

[Wasay-Gumloop]

Thank you for trying that @Radvin18tid – I cut a ticket to investigate this further, will keep you posted!