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.

  • Home
  • Get Help
  • Troubleshooting
  • Xero and monday.com - Creating Duplicate Items Instead of Updating, "Update Column Value" Action Not Available
Question

Xero and monday.com - Creating Duplicate Items Instead of Updating, "Update Column Value" Action Not Available

  • 4 May 2023
  • 1 reply
  • 29 views
sarabi
Userlevel 1

I have xero and monday.com integrated through zapier.

In Monday, I have a board which acts as an onboarding tracker for clients. It includes columns for client name (company), first name, surname, email address, account number (which I was thinking in step one below I could make the monday item ID?), deal value and status.

Can you give me the steps I need to take in zapier, xero and monday to make the following happen:

1. when a new item/client is entered into the monday board, a contact is created in xero with their details
2. When a quote is sent to a client from xero, the status column and deal amount column for that client/item in Monday is updated.
3. When a payment is received from a client in xero, the status column and deal amount column for that client/item in monday is updated.

When I have tried, each time xero sends back quote generated or invoice received, it’s creating new items/lines in monday rather than using the existing ones (with account number matching monday item ID) and updating their status. The how-to I found online told me to use the "Update Column Value" action event, but that doesn't exist as an option.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Rank
Userlevel 7
Badge +11

Hi @sarabi, welcome to the Community!

It sounds like the issue is that the Zap is creating new items in Monday instead of updating existing ones with the matching account numbers (item ID). Am I understanding that correctly?

If yes, are you using a Create Item action in the Zap to update the existing items as the “Update Item Column Value” action is no longer available? Asking as that may explain why it’s creating new items as that action cannot update existing items. 

If that’s the case, I’d suggest switching the Zap to use the Change Multiple Columns Value (Monday.com) action, as that would be able to update the existing item. That said, in order to ensure that the correct item is updated by that action you’d need to select the Item ID field (using the Custom value option) from the Monday.com trigger in the Zap.

For example:
8013bf1a3918891bebea4b6c9519af9e.png

Doing that would allow the action to select the same Monday.com item that triggers the Zap and update it accordingly. 

Can you give that a try and let us know whether that gets it working?

Hopefully that’ll fix it, but if it doesn’t, or I’ve misunderstood the issue here please let us know! 🙂

Terms & Conditions