Skip to main content
Best answer

Failed to create a database item in Notion: {variable} is expected to be rich_text.


Hello, 

I’ve create a Notino database with the column named TestA, and it’s a text column. 

I’m pulling some data from Asana (custom Extension App), and when I put the output to the Notion database I always have this errorr: {variable} is expected to be rich_text.

None of the options under “Formatter by Zapier” helped.

 

Does anyone knows how to get rid of this error?

Best answer by Troy TessaloneBest answer by Troy Tessalone

@trzsfolio 

According to the screenshots you provided the field is a dropdown field.

You may need to refresh the fields in the Notion Zap step.

Can you post screenshots with how the field is configured in Notion?

View original
Did this topic help you find an answer to your question?

10 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @trzsfolio 

Good question.

Can you post screenshots to give us more context?


  • Author
  • Beginner
  • 5 replies
  • November 20, 2023

Hi @Troy Tessalone 

Sure. 

I’ve attached the screenshot of the error, the action and the data used for the action. 

 


Troy Tessalone
Forum|alt.badge.img+14

@trzsfolio 

Only 1 of the 4 attachments uploaded.

 


  • Author
  • Beginner
  • 5 replies
  • November 20, 2023

Hi @Troy Tessalone 

I’ve re-uploaded the files. 


Troy Tessalone
Forum|alt.badge.img+14

@trzsfolio 

The field “Some testing” is a dropdown field that has a list of options.

Check this help article about how to map dynamic values properly: https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T

 


  • Author
  • Beginner
  • 5 replies
  • November 20, 2023

Hi, 

The field “Some testing” is a text column in a Notion database. 
I don’t want to use the dropdown field. This is why I used the custom configuration because I want to take a custom value from an output of the App Extension from the 4th step. 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31416 replies
  • Answer
  • November 20, 2023

@trzsfolio 

According to the screenshots you provided the field is a dropdown field.

You may need to refresh the fields in the Notion Zap step.

Can you post screenshots with how the field is configured in Notion?


  • Author
  • Beginner
  • 5 replies
  • November 20, 2023

@Troy Tessalone sure. 

The issue is that the text from the custom value isn’t rich text. And Notion only accepts rich text for Databases. 

 


Troy Tessalone
Forum|alt.badge.img+14

@trzsfolio 

Please provide these 2 screenshots:

  1. How the field is configured in Notion
  2. The list of options from the ‘Some testings’ tab to the left of the ‘Custom’ tab.

 


  • Author
  • Beginner
  • 5 replies
  • November 22, 2023

Hi @Troy Tessalone 
I found out the issue. 

The Notion fields weren’t correctly refreshed the first time. 

 

After refreshing it, it was working. 

Thanks for the help !

 


Reply