Microsoft Dynamics 365 | Integration, Dataverse...

Reading optionset value if it s null return null

(0) Share

Report

Posted on by Abhilash M abi

595

i'm retrieving optionset value through plugin on create of record i'm calling the plugin...

my problem is i have option set field with optional (not mandatory) but if it is not selected any values... then i'm getting exception... if i selected any option then it is returning value....

is there any suggestion to this, i need to get null if optionset is not selected

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I believe you use code that is similar to following:

var optionsetValue = (OptionSetValue)entity["optionsetfieldname"];

in order to resolve your issue try to use following syntax instead:

var optionsetValue = entity.GetAttributeValue<OptionSetValue>("optionsetfieldname");

If there will be no value - it will return null.

Was this reply helpful? Yes No
Suggested answer

Filipe Relvas on at

Like (0)

Report
Hi Abhilash,

When you create or update a record and trigger a Plugin, the Plugin context usually comes with the attributes that were filled or changed by the user i.e. attributes are seen as dirty.

Any other attributes will not be part of the context, hence why they come as null, but can be obtained through an Organization Service request using the GUID of the Entity record that triggered it.

If you do have the necessity to get the Option Value even if it's not mandatory I would suggest one of two options:

Get it through the Organization Service: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/write-plug-in#organization-service

Change the Field Submit Mode to "Always" through a Client Side Javascript. By doing this you will ensure the Field always comes in the Plugin Context whether it was changed by the user or not: https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/attributes/setsubmitmode

Hope this helps!

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

You can also check if entity object contains that attribute and then get the value.

int optionSetValue=-1;

if(entity.Attributes.Contains("fieldschemaname") && entity["fieldschemaname"]!=null)

optionSetValue=((OptionSetValue)entity["fieldschemaname"]).Value;

Now if field is null then it will return -1 else it will return the optionset value selected by the user on UI.

If found helpful, Please mark my answer verified.

Was this reply helpful? Yes No