How to retrieve an option set label

[paul_matthews]

Hi

I am looking at the prospect of converting some of my D365 workflows over to use Power Automate.  However I seem to be having an issue with which seems a simple request.  I have created an automated flow and am trying to send a Teams message to a channel when the rating field on the lead record is updated.

The objective of the Teams message is to inform the user of the update, and therefore I want to include the label of the new value in the message.  However the value is displayed all the time, so 0,1 instead of Cold, Warm.  I have tried a few of the options that I have found, however unsuccessfully.

Thanks for your help

Paul

[abm]

Hi @paul_matthews 

We could only select Option Set Field_[Value] property (dynamic content) within the Dynamic content panel.

If you want to get the text then use Option Set Filed_[Label] property within your flow as expression.

Please have a look at this post below.

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/I-want-using-Option-Set-field-choos...

Thanks

[paul_matthews]

Hi abm

Thanks for your response.  I did see this post but could not get the structure of the Select action correct.

I am receiving the following error "InvalidTemplate.  Unable to process template language expressions in action "Select" inputs at line '1' and column '11891': 'The template function 'value' is not defined or not valid"

Could you please let me know what the value of the From field should be in this scenario.

thanks

Paul

[abm]

Hi @paul_matthews 

Could you please post your expression of Rating Value Label?

Thanks

[abm]

Hi @paul_matthews 

Apologies, I should have mentioned earlier that the label expression which I posted can only get via Dynamics connector. Not using CDS. So for CDS you need to use the string map entity to retrieve the label text against entity name and optionset value.

Thanks

[paul_matthews]

Hi @abm 

Thanks, I have found the following post that you responded on which is related to using the String  Map entity

How to read multioptions set from dynamics 365 

However I am not using a list of records, as I only have a single record that has been updated.  Have you got an example of using the String Map entity for retrieving the label of an option set for a single record. 

Should I be seeing String Map as an entity in my environment? e.g. data->entities

thanks

Paul

[abm]

Hi @paul_matthews 

You can't access the string map entity from Dynamics advanced find. How ever if you use xrmToolBox kit you can access the entity.

What connector are you using? CDS?

Thanks

[cdcs]

.

[paul_matthews]

Hi @abm 

Yes, I am using the CDS connector, and am struggling to understand how I would use the String Map option. For something so straight forward in D365 workflow, this seems like it should be easier in Power Automate.

Have you got a link to an example of using the String Map which is similar to my scenario.

thanks for your advice and help

Paul

[paul_matthews · Accepted solution]

right then, I have managed to get the option set value. 😊.  For everyone else with this issue here is how I did it

The full expression is Triggeroutputs()?['body/_leadqualitycode_label'].  The main issue I have is that this will only work with the CDS connector and not the CDS (current environment) connector as the label value is not returned in the JSON for the CDS (current environment) connector.  I hope this is fixed in the future as the current environment connector provides more Actions and is more efficient for processing lists of record. 

If you wanted to do this from a different record than the record that triggered the flow then use the Get Record action and then the following expression Outputs('Get_record')?['body/_leadqualitycode_label'] where 'Get_record' is the name of the action.

Hope this helps someone.

thanks

Paul

[abm]

Hi @paul_matthews 

This a good find. I always use solution for flow and used default environment connector. I am surprised that that feature is not available for other connector. Hopefully MS will fix this soon.

Thanks a lot

[LinnZawWin]

@paul_matthews and @abm 

With the latest update of Common Data Service (current environment) connector, you can now query the formatted values of supported field types such as lookup display name, option set value label, formatted date/time by using the OData.Community.Display.V1.FormattedValue property of the field in the expression.

https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html

[paul_matthews]

Hi @LinnZawWin 

Yes I noticed that.  Great news and really good the platform is continually being improved.

Thanks

Paul

[powerwood]

I add "_label" to the end of the desired choice field, but the result is a blank space when the Flow runs. Is anyone else having this problem?

[paul_matthews]

Hi powerwood

Are you using the correct connector?  you should be using the CDS Connector (Current Environment).

However I would recommend looking at the comment above from @LinnZawWin as this is a great way of doing what you require

https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html

Hope this helps

Paul

[Boneckrh19]

You would need to also add an underscore to the beginning on the desired choice field.

leadqualitycode
vs
_leadqualitycode_label

There is also a new possibility, which I've found only for specific actions in newer flows. If it fails on the underscore version of the field, try this instead:

leadqualitycode@OData.Community.Display.V1.FormattedValue 

I truly dislike this possibility because it is incredibly more cumbersome to type out and read through, but I have seen this come up especially for new dataverse triggers

[abm]

For a choice field there are two properties. One is the value and other is the text which is the label. This is syntax you need to use to get the label.

Thanks

[JeckGill]

is "_leadqualitycode" your schema name or logical name?

[LinnZawWin]

@JeckGill 

"leadqualitycode" (without _ prefix) is the logical name of the column. In cloud flows, only the logical name of the columns is used and the schema name (with capitalised name) is not used.

[Boneckrh19]

@LinnZawWin that's not necessarily true. The schema name is what flow seems to want when you are filtering through a lookup field or doing an expand query in a List Rows dataverse action