Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a form with a checkbox option to select multiple departments.  I need a custom field in Clickup updated based on those selections.  I’ve set up multiple steps to format the value to match ClickUp’s Ids, but still getting an error:  "Values must each be a valid option id".  

The user may select zero or up to all the checkbox and each one should be selected on the custom field.

After a new entry is submitted on the form:

 

Line Itemizer to separate each checkbox from the form.

 

2nd - look up table to match the ClickUp field

3rd I split the text so they are separate items.  I’ve tried All (as line-items) and All (as separate fields)

When I create the task, I select the output from the last step.  

 

 

Hi @Kim_M 

Try mapping the output variable from the Formatter > Utilities > Lookup Table step.

@Troy Tessalone  I tried that originally and receive the same error.  That’s why I was thinking, I needed to separate them with Split Text.  

 

@Kim_M 

Perhaps one of the values you typed in the Lookup Table is not a valid value for the field.

Can you post screenshots of the error?

 

Can you post screenshots of the dropdown list options?

 

The field expects an array of items.

The output from the Formatter > Utilities > Lookup Table returns the results as an array of items.

 

 

 

 

 

 

Here is the error when I use the lookup table output.

 

 

The options for the dropdown.

Here is the output when all 3 are selected.

 

@Kim_M 

An option to try…

You may have to flatten the array from Formatter > Utilities > Lookup Table with Formatter > Utilities > Line Item to Text

Then with Formatter > Text > Split set Segment Index to All (as Separate Fields).

Map each of the 3 possible options individual variables to separate inputs for the Field.

 

 

 

That worked!

Reply


Terms & Conditions