Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Issues with Fetching Data Using Lookup in Multiple Table Rows | Clay

Issues with Fetching Data Using Lookup in Multiple Table Rows

·Jul 28, 2025 04:38 PM·

Hi team, When I am trying to fetch the data from another table using lookup multiple rows from another table, I am unable to select a table as it says "No Options Found". Could you please let us know what is the issue here and resolve it?

Loading attachments

3 comments

· Sorted by Oldest

Clay
APP
·
·
The "Lookup Multiple Rows in Other Table" action requires specific inputs to function properly: Table to Search, Target Column, Filter Operator, and Row Value. When you see "No Options Found" for table selection, this typically indicates that there may not be any accessible tables in your workspace, or there could be a configuration issue. The lookup feature allows you to search and retrieve data from other tables in your workspace, enabling connections between tables based on specific criteria. You can only use one column at a time to filter with this enrichment, and it pulls multiple rows that meet your search requirements. Are you working within a workspace that contains multiple tables, and do you have the necessary permissions to access those tables?
Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay
Clay
APP
·
·
Hello Nicolas! Thanks for reaching out! Do you mind sending over the table link for me to take a look?
(52 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.