Skip to main content
Question

Create a simple mapping for drop down values?

  • June 9, 2025
  • 3 replies
  • 37 views

I’m working with Hubspot CRM into Dynamics 365 CRM and all I want to do is create a simple field mapping for the IDs within a drop down field. Even though the naming in the dropdowns is the same, we all know that the system uses the ID for each choice. All I want to do is map the IDs appropriately. For example, in Hubspot, choice #1 needs to map to Dynamics choice #800.

 

Right now when I use the Custom Value from Hubspot, I get an error of:

The app returned "A validation error occurred. The value 0 of 'xxx_globalproductgroupsingle' on record of type 'opportunity' is outside the valid range. Accepted Values: 892230000,892230001,892230002,892230003,89223000...". 

 

 

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

3 replies

  • Author
  • New
  • 1 reply
  • June 9, 2025

I figured this out using a Zapier table where I put the Hubspot values in one column and the Dynamic values in another column. This seems to work as expected. 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34070 replies
  • June 9, 2025

Hi ​@trosenthal 

Options:

  • Formatter > Utilities > Lookup Table
  • Zapier Tables
  • Airtable
  • GSheets
  • etc.

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9736 replies
  • July 8, 2025

Hi there ​@trosenthal 👋

Did any of the options Troy suggested do the trick?

Let us know how you’re getting on, want to make sure you’re all set! 🙂