Others

Troubleshoot Integer Option Set Mapping in Dynamics 365 with KingswaySoft

Steve KSteve K Nov 20, 2026 868 views

Question details

The user needs guidance on mapping an integer-based Dynamics 365 CRM option set when KingswaySoft displays nvarchar input values.

Troubleshoot Integer Option Set Mapping in Dynamics 365 with KingswaySoft
Product
Microsoft Dynamics 365 CRM and KingswaySoft
Device & OS
not provided
Scenario
Mapping a source column to a Dynamics 365 option set through the KingswaySoft OptionSet Mapping Editor.
Observed behavior
The mapping editor displays nvarchar input values although the option set uses integer values.
Before you start

Identify the source column data type, the destination option set field, and the option set values. Have the relevant KingswaySoft mapping configuration available for review.

Solution 1Recommended

Ask the Dynamics community about the mapping configuration

Use this route to get specialized guidance on the Dynamics 365 and KingswaySoft integration.

1
Review the source and destination

Open the integration package and inspect the source column metadata, the destination field, and the OptionSet Mapping Editor configuration.

2
Gather the option set definition

In Dynamics 365, locate the destination field's option set definition and record its labels and integer values.

3
Post the integration question

Visit https://community.dynamics.com/ and post in the Dynamics community. Include the option set definition, source column data type, destination field, mapping configuration, and the nvarchar behavior you see.

Ask the Dynamics community about the mapping configuration
Scope of the issue: This is a Dynamics 365 CRM and KingswaySoft integration question, not an Office 365 issue. The displayed input type alone does not establish the cause.
Free Microsoft Office alternative

Document Your Integration Configuration in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for a smooth transition. Use it to document mapping details, though it does not fix the Dynamics 365 or KingswaySoft integration.

Organize source types and option set values in a spreadsheetOpen and edit Microsoft Excel XLSX and Word DOCX filesUse a familiar, easy-to-use interfaceWork with a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does the OptionSet Mapping Editor show nvarchar inputs?

The cause cannot be determined from the displayed type alone. Share the source metadata and mapping configuration with the Dynamics community or KingswaySoft support for review.

What information should I include in a support request?

Include the source column data type, destination field, option set labels and integer values, mapping configuration, and a description of what the editor displays.

Is this an Office 365 issue?

No. The question concerns integration between Dynamics 365 CRM and KingswaySoft, so the Dynamics community is a more suitable place to ask.

Can WPS Office fix the option set mapping?

No. WPS Office can help document the configuration in a spreadsheet or document, but the mapping must be investigated in the Dynamics 365 and KingswaySoft integration.