Troubleshooting Issues with Lookup Function in Approval Process

Hello everyone! I would really appreciate your help with this situation. I have 2 tables, one generates a list of companies, the other a list of people that work in those companies. In the first table, I send a message to a slack channel for approval. If approved, it then marks the cell as "approved". In the second table, I want some actions to only run if they've been approved. For this I'm using the "lookup single row in other table" function. It's showing me a lot of different fields, but for some reason, that one in particular that contains the "approved" message, doesn't show up. Why is this happening? How to fix this? Thank you in advance!

7 comments

Clay
APP
·
·
The "approved" column isn't showing up because you need to re-run the lookup after creating new columns. When new columns are added to a table, existing lookups don't automatically see them. To fix this: Click on your lookup column header and select Force Rerun Column. This will refresh the lookup and make all current columns from the source table available for selection.
David R.
·
·
Unfortunately that's not worked. Is it something to do with formats?
Clay
APP
·
·
Yes, it could be format-related. Try checking the column data type of your "approved" field: 1. Click on the column header in your source table 2. Select Edit Column > Select Data Type 3. Ensure it's set to the correct data type (likely Text) 4. Click Save Settings Then go back to your lookup column and try Force Rerun Column again. Different data types can sometimes prevent columns from appearing in lookup selections.
Sources: Table columns | Documentation | Clay University Select Column Data Type
David R.
·
·
Here's another image for more context, on the results of the Lookup
Hari K.
·
·
Hey David! Happy to take a look into this - can you share the link to the table so I can dive in?
David R.
·
·
Still not fixed!
Hari K.
·
·
Hey David! Happy to take a look into this - can you share the link to the table so I can dive in? For context, you can share it here on Slack or via our native chat on Clay

Troubleshooting Issues with Lookup Function in Approval Process | Clay