cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Shannon

Dynamics CRM - Get OptionSet Text (instead of value)

Submitted by Advocate IV on ‎02-08-2017 08:14 AM

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
See more ideas labeled with:
10 Comments (10 New)
Comments
Anonymous
Not applicable
‎07-20-2017 06:08 AM

Useful for sending notification emails from Flow

vmoskalenko
Frequent Visitor
‎09-15-2017 05:07 AM

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

SandyDevin
New Member
‎03-02-2018 12:23 PM

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
‎07-19-2019 03:24 AM

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

Anonymous
Not applicable
‎09-18-2019 06:18 AM

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
‎10-22-2019 11:51 AM

This is needed in order to generate emails

thomaspayne
Regular Visitor
‎04-24-2020 02:19 PM

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
‎07-09-2020 06:59 PM

We require text to send with email

carterbarry88
Advocate I
Advocate I
‎10-02-2020 03:03 AM

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
Advocate I
‎01-28-2021 01:44 PM

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']