27
I added a new field to the account entity. and I'm creating new accounts using the API and want to be able to provide the text and not the table value.
<Property Name="new_industry" Type="Edm.Int32"/>
Basically I want to provide "Airline / Aviation" and the get back "100000002" or just be able to provide "Airline / Aviation" and the CRM will convert it automatically in the POST requests.
"value": [
{
"name": "Test with 1111",
"new_industry": 100000002
}
]
Hi maorlv,
Optionset value is restrict to integer type thus we can only set it with whole number when creating/updating records with option set field.
However, you can get/retrieve the text/label with formatted value, please take these threads as reference if they could meet your demand:
http://himbap.com/blog/?p=2077
In addition, you could paste following script and execute it in Console tab in developer tool in your CRM tab to quickly get an optionsetItem array of an optionset field and view each item value and text:
Xrm.Page.ui.controls.get("new_industry").getAttribute().getOptions();
Regards,
Clofly
Hi there,
You need a custom entity with conversion records to be able to do this.
See for more info:
community.dynamics.com/.../how-to-use-dynamics-optionset-labels-within-powerbi
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (