How Decode Choices in Dynamics CRM 365 Using Python or SQL

(0) Share

Report

Posted on by carltonp

Hello Community.

My first post here,

I have been using the following link to retrieve to decode option sets in a table

https://github.com/slavatrofimov/Synapse-Link-for-Dataverse-data-enrichment-in-Serverless-SQL-Pools/blob/main/SQL/Enrich%20Synapse%20Link%20for%20Dataverse%20Entities%20with%20Human-Readable%20Labels.sql

This works well if it is applied to Azure SQL Serverless Pool, however, can someone let me know if there is are any other methods that can used to achieve the same result but using Python?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

fabipfr 13 on at

Like (0)

Report

How Decode Choices in Dynamics CRM 365 Using Python or SQL

I understand your trying to decode option set values and what label they are mapped to?

e.g. statuscode 0=active, 1=inactive

if this is what you're looking for there is a popular browser extension "level up for dynamics". if installed, navigate to a record of the entity you want to know the option set values of. click the extension > Forms > Show Option Set Values.

Also there is the option to navigate to the table settings over make.powerapps.com. entity > columns > your option set column > edit. your able to see the labels and mapping there.

Was this reply helpful? Yes No