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

Monday.com get column value and change column with pulled value

  • 24 August 2022
  • 4 replies
  • 725 views
M

 

Hi All,

 

I have an issue with the change of a column in Monday.

 

I pulled data from an item with the “Get column value” action and now want to change another item’s column in another board with the pulled “person” value.

  1. Get column value

 

  1. Change column value

 

 

It works as long as I do not use the value I retrieved in the step before.

The error message is the following:
 

 

 

Can anyone help with that? 

 

Much appreciated, thank

Matthias

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

4 replies

M

Update to the below: maybe the problem is that the “Get column value” does not retrieve the User-ID, but the user name instead and user name cannot be sent via “Change multiple column values” back to a column in Monday.com.

Danvers
Userlevel 7
Badge +12

Hi @matmid01!

From the screenshots you shared, I would agree that the most likely cause is using the person name and not the person ID. Is Person one of the columns in the board that you’re sending the information to?

 

Looking at the monday.com integration triggers and actions, there isn’t one that will find a user (and therefore get you the ID). There is a feature request for adding a Find person action - would you like to us to add you to the list of interested users?

 

In the meantime, one way to work around this would be to export a list of the people in monday,com with both the name and ID. You could add this to a Google Sheet and use a Find Row step to search by name and retrieve the ID from the sheet, which you could add to the second monday step. Obviously, you would need to add each new person in monday.com to the sheet, so it’s not a very efficient work around, sorry about that. 

 

I’m sorry that I don’t have better news for you on this - let me know if you’d like to be added to that feature request!

MohSwellam
Userlevel 7
Badge +8

Hi @matmid01 , 

 

First you would need to lookup that Person in Monday to get the ID of the row you want to update then you can use the Change Value step. 

 

Can you try and let me know if this works?  

Founder of GeekyAir.com
christina.d
Userlevel 7
Badge +9

Hi there, @matmid01! I wanted to swing by and see if you were able to get this sorted?

Keep us posted - we’d love to know. 🤗

Terms & Conditions