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.

Best answer

Notion “Invalid select option, commas not allowed” error

  • 22 December 2021
  • 5 replies
  • 881 views
H

I created a lead generation form in Typeform ,everything is working fine but, I am facing a problem with one item in my notion database which causes my zap to fail. below details are provided.

 

  1. I have a question in my “Typeform” which is multiple choice with multiple selections disabled thus only one choice can be selected. 

    Typeform multiple choice question with multiple selection disabled
     

 

 

  1. Created a “select” property in notion as it shows in the picture
    Notion Property Type

 

  1. When zapier is running it says that commas are not allowed and I don't want to delete commas from my Typeform because it represent numbers and I am using commas so that numbers can be easily readable.
Zapier Error

 

 

 

I tried to change the property in notion to “multiple selection” , then the zap worked but the selection text are splitted by comma, It should be $3,000 - $10,000

 

 

icon

Best answer by Troy Tessalone 22 December 2021, 17:21

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

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Hani Aago

When creating a database item, I’m getting an error about an invalid option

When using field types “Tags”, “Select”, or “Multi-select”, the tags or options used need to be created in the database in advance. Go back to the database in Notion and add the tag or options to a database item first.

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

Hi @Hani Aago

When creating a database item, I’m getting an error about an invalid option

When using field types “Tags”, “Select”, or “Multi-select”, the tags or options used need to be created in the database in advance. Go back to the database in Notion and add the tag or options to a database item first.

 

I already created the tag in notion which is a “select” property 

It seems zapier can’t run text with comma for a “select” property

H

Here are the tags that created for the select property in notion , the same as in the Typeform

 

I am still getting the error when I choose that data entry for zapier as shown below

 

Or should I put the data entry like this

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Hani Aago 

These values still are different, thus the error.

The values from Typeform have commas.

The values in Notion have no commas.

Try adjusting your Notion field options to have commas to match.

Otherwise, you can use a Formatter > Utilities > Lookup Table Zap step to translate the value formats: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

 

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

I understand now , the problem is that Notion field options can’t have commas if I want to use a select property .

I couldn’t do the solution that you provided. it is so complicated but, instead of that; I created the Notion field as a “plain text” and it worked.

Thanks

Terms & Conditions