About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Cannot read property 'column_values' of undefined in Monday.com

  • 30 October 2023
  • 3 replies
  • 25 views
P

I’m getting an error when trying to send some leads data to Monday.com via Zapier with an error of Cannot read property 'column_values' of undefined. I have a column value called email in my Monday board, so i’m a bit confused on what i’m missing here. Please see the screenshots below for more context. For additional context, the lead capture tool is sending callback data at three different times with some duplicate data. I’m trying to avoid duplicate items being created in Monday.com, so i’m trying to ‘Get Item by Column Value in monday.com’ to see if an email exists for that lead. If not, then we consider that a success to continue to the path options. If there is a zap search status of false, then I want to ‘Create item in monday.com’. If the zap search status is true then I want to ‘Create Update in Monday.com’ to update the existing item in Monday.com with some extra lead data.  Please let me know if there is any additional information that is needed

Overview of zap flow
lead capture tool

 

3 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Phil21 

Good question.

The issue may be related to the dropdown field types.

Dropdown field have a list of standardized options.

Each option in the list has 2 values (top/bottom).

If you are trying to map a dynamic variable from a previous step, then the variable value must match the bottom value for an option.

EXAMPLE

 

 

You’ll probably want to add a space between the mapped variables.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

Thanks for the quick response @Troy Tessalone. That fixed the error, however the zap is not quite working as intended. I want to be able to check Monday.com to see if an email exists and if it does exist, then I simply want to update the existing item in Monday.com with some of the new lead data that was received. Currently, my zap is running three times to create a new item in Monday.com each time which is due to multiple callback functions getting triggered as the lead fills out the form. Do you know how I would go about doing this? Here is an example of my Monday.com board and the output as well as another screenshot of the paths as the initial screenshot had the names of the paths mixed up. 

 

Troy Tessalone
Userlevel 7
Badge +14

@Phil21 

If the Zap is being triggered multiple times for the same data, then that might be an issue with the app being used in the Zap trigger step.

Have you tried reaching out to that app’s support?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

Reply


Terms & Conditions