Skip to main content
Answer

monday.com error: Invalid value for {"personsAndTeams"=>[{"id"=>nil, "kind"=>"person"}]} on MultiplePersonColumn. invalid value

  • December 7, 2023
  • 7 replies
  • 100 views

Hello

I am trying to change multiple column values in monday.com for an item but I get an error

“Invalid value for {"personsAndTeams"=>[{"id"=>nil, "kind"=>"person"}]} on MultiplePersonColumn. invalid value”

 

 

Best answer by Troy Tessalone

@CSS 

Check the link for help configuring the Game Planner field.

The Game Planner field description indicates it expects the internal User IDs.

You may need to add additional lookup steps or a lookup table.

Help article to reference: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 

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

7 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 7, 2023

Hi @CSS 

Good question.

We would need to see screenshots with how your Zap step 5 is configured along with the encountered error.


  • Author
  • New
  • December 7, 2023
@Troy Tessalone 
The rest of the fields are blank

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 7, 2023

@CSS 

Make sure to review the field descriptions for guidance on how to configure the valid values for each field type.

Help article to reference: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 


  • Author
  • New
  • December 7, 2023

Thanks @Troy Tessalone 

I was able to update the date using formatter by Zapier. Is there any way to add the person name as a variable?

Scenario:
We have two persons who attend calls: p1 and p2
Lead/contact books a call using acuity calendar and lets consider that the call was booked on p1’s calendar. I want the ‘Game Planner’ field updated with p1’s name in it.
Similarly if a call is booked on p2’s calendar, the ‘Game Planner’ field should be updated with p2’s name in it.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • December 7, 2023

@CSS 

Check the link for help configuring the Game Planner field.

The Game Planner field description indicates it expects the internal User IDs.

You may need to add additional lookup steps or a lookup table.

Help article to reference: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 


  • Author
  • New
  • December 7, 2023

Thanks a ton @Troy Tessalone 
Its working all good now :)


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • December 8, 2023

That’s an amazing news @CSS! Big thanks to Troy for lending a hand here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊