Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Where can I find the d...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Where can I find the data values in Option Sets?

(0) ShareShare
ReportReport
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

  • Suggested answer
    Pawar Pravin Profile Picture
    Pawar Pravin 5,227 on at
    RE: Where can I find the data values in Option Sets?

    FYI,

    pravinpawarweb.wordpress.com/.../

  • Suggested answer
    Fubar Profile Picture
    Fubar 2,752 on at
    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.

  • necsa Profile Picture
    necsa 3,455 on at
    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.

  • JonClay Profile Picture
    JonClay on at
    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

  • Suggested answer
    necsa Profile Picture
    necsa 3,455 on at
    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/

  • JonClay Profile Picture
    JonClay on at
    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

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    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

  • JonClay Profile Picture
    JonClay on at
    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

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Where can I find the data values in Option Sets?

    Hello Jon,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans