Microsoft Dynamics 365 | Integration, Dataverse...

Where can I find the data values in Option Sets?

(0) Share

Report

Posted on by JonClay

Hi everyone

I'm very new to Dynamics 365, so please forgive me if this is a silly question.

I've output our Contacts table which includes the fields sic_maritalstatus, si_type and sic_gender as shown on the attached image. As you'll see, the Marital Status (usually either Single or Married) is shown as a numeric value. This is the same for the Type and Gender fields.

All these fields are based on Option Sets within CRM, and I assume that a table / entity must exist which has these codes alongside their text values (e.g. 907510002 = Married etc).

Where would I find this table / entity, or is it in a different place for each set up of Dynamics? Am I able to find out from within Dynamics itself?

Many thanks
Jon

7041.Option-Sets.PNG

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

RE: Where can I find the data values in Option Sets?

Hello Jon,

Pairs of Values/Labels could be found in the StringMap view.

Was this reply helpful? Yes No
JonClay on at

Like (0)

Report

RE: Where can I find the data values in Option Sets?

Hello Andrew

Many thanks for your reply. Is this Entity also available in the Online version as I can't find it when creating a Data Connection from within Excel?

Many thanks

Jon

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

RE: Where can I find the data values in Option Sets?

Hello Jon,

I have no idea on how to connect Excel to CDS Online but the data feed available by URL <your crm org here>/api/data/v9.0/stringmaps

Was this reply helpful? Yes No
JonClay on at

Like (0)

Report

RE: Where can I find the data values in Option Sets?

Hello Andrew

Brilliant, thank you. I'll give it a try.

Best wishes

Jon

Was this reply helpful? Yes No
Suggested answer

necsa 3,455 on at

Like (1)

Report

RE: Where can I find the data values in Option Sets?

Hi JonClay,

I respect the answer from Andrew. Hereby I send you a link to how to export option field value as text.

I hope it will be helpful and understand your issue.

https://www.loganconsulting.com/blog/export-option-set-method-in-microsoft-crm-2016/

Was this reply helpful? Yes No
JonClay on at

Like (1)

Report

RE: Where can I find the data values in Option Sets?

Hi Necedet

Thank you very much, I will try that too.

Best wishes

Jon

Was this reply helpful? Yes No
necsa 3,455 on at

Like (1)

Report

RE: Where can I find the data values in Option Sets?

You welcome Jon Clay.

One for everyone, everyone for one. I advise you to follow Andrew's blog. He is a great helper.

Was this reply helpful? Yes No
Suggested answer

Fubar 2,761 on at

Like (1)

Report

RE: Where can I find the data values in Option Sets?

In addition to using the table Andrew suggested, you can also extract the data dictionary (includes the numbers and values against the fields) to word or excel by using the XRMToolBox tool (free) with its Metadata Document Generator plugin/add-in.

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

RE: Where can I find the data values in Option Sets?

FYI,

pravinpawarweb.wordpress.com/.../

Was this reply helpful? Yes No