Troubleshoot Integer Option Set Mapping in Dynamics 365 with KingswaySoft
Question details
The user needs guidance on mapping an integer-based Dynamics 365 CRM option set when KingswaySoft displays nvarchar input values.

- 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.
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.
Ask the Dynamics community about the mapping configuration
Use this route to get specialized guidance on the Dynamics 365 and KingswaySoft integration.
Open the integration package and inspect the source column metadata, the destination field, and the OptionSet Mapping Editor configuration.
In Dynamics 365, locate the destination field's option set definition and record its labels and integer values.
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.

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.

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.




