Customer experience | Sales, Customer Insights,...

Negative OptionSet value

(0) Share

Report

Posted on by alireza.majma

Hello,

I have a question regarding OptionSet Value

We are using API to connect Dynamics and importing data to our system,

It is obvious that OptionSet value should be a positive number but we received -1 as OptionSet Value.

We know it is an invalid value and it should be ignored and consider as null.

My question is,

where this value comes from . how it was populated. is there and special scenario that Dynamic fill option set with -1

I appreciate your help in advance

I have the same question (0)

All responses (4)

Answers (0)

Guido Preite 54,086 Moderator on at

Like (0)

Report
Copy link

Link copied!

from what you are describing to me looks like you are connecting to a custom API and not directly to Dynamics API.

Probably the custom API returns -1 under certain conditions, afaik it's not possible to receive a negative number for optionset values when using the OOB Dynamics API.

Was this reply helpful? Yes No
Suggested answer

tanay@D365 45 on at

Like (0)

Report
Copy link

Link copied!

Can you please check if the CRM table contains the value as -1 in the Database ? You can use SQL4CDS in XRM Toolbox www.xrmtoolbox.com/.../

you can run a select query on the table in question and check what value is stored there (I will be surprised to see a -1 value stored as Optionsetvalue in CRM though)

Was this reply helpful? Yes No
Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hello.

Please check the API which is returning the -1 value. You should check if optionset value is not set or null

Was this reply helpful? Yes No
Edwin VC 8 on at

Like (1)

Report
Copy link

Link copied!

I know this is an older post already, but I currently experience the same issue and it causes a problem when using Custom Forms showing a 'Invalid Data from Network' message.

I found that indeed the OptionSet can have a negative '-1' value based the user selecting/reverting to the '--select--' option in the default OptionSet Control, presumably when a user tries to clear the selected value. But the '--select--' is not part of the metadata configuration and there is no setting that will allow us to disable the '--select--' option.

In the end this does not result in a critical issue for this implementation, everything works as expected, only the message is shown when a Custom Form with a grid (gallery) is displayed. The value in the gallery showing the value for the OptionSet as a text value is blank as to be expected. Setting the OptionSet value to an actual OptionSet value will resolve the issue. Using a workflow to 'clear' the value (value is null) will also resolve the issue.

If anybody has a suggestion on how to suppress the 'Invalid Data from Network' message without difficult work-arounds that would complicate future maintenance let me know.

Was this reply helpful? Yes No