cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamics CRM - Get OptionSet Text (instead of value)

It seems like it would be useful to have access to the text of an OptionSet, for use in Flow. Rather than having to translate a number like 123000001.

Status: New
Comments
tiberriver256
Advocate I

Useful for sending notification emails from Flow

vmoskalenko
Frequent Visitor

Useful for showing text values on external apps (in read only mode)

SandyDevin
New Member

We want to show the value of a Boolean as Yes or No in an email from flow. The CRM field is a two option set, and we want to value Yes not true, and No not false.

Joseph_Bowman
New Member

Would be great for automation for company forms into a word template

Anonymous
Not applicable

Would be a great help as i do not see a way to format the code values to text with any other option.

 

Adding to this I would like to be able to map optionsets from Forms Pro responses to Dynamics 365 CE. 

ERWest
Frequent Visitor

This is needed in order to generate emails

thomaspayne
Regular Visitor

Agreed, creating a 13 page word document with lots of option sets, and it is the text I need, not the number behind the scenes.

Prigail
New Member

We require text to send with email

carterbarry88
Advocate I

Useful for email sends or anything that needs to be read by someone so word template or potentially copying a value from one place to another if required

rw_ga
Advocate I

Its absolutely ridiculous that almost 4yrs later and its still a PITA to do this in a flow.  We use the text values in emails, word documents, and all sorts of other user friendly ways.  Not having a way to grab the text version of the optionset from a trigger is absurd!  We are supposed to migrate our background workflows over to cloud flows and its a PITA.  Yes flows can do a LOT, but they are also limited in so many ways...

 

The fact that we have to work around this by adding a Get a Record action for the triggered record, then typing in manually the following in the expression field is crazy.

outputs('YOURGETARECORDACTIONNAMEGOESHERE')?['body/YOURCOLUMNNAMEGOESHERE@OData.Community.Display.V1.FormattedValue']