Answered

How to retrieve an option set label

(1) Share

Report

Posted on by paul_matthews

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.

optionset value.jpg

Thanks for your help

Paul

Categories:

Building flows

I have the same question (0)

All responses (20)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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-choose-label-value/m-p/162486

Thanks

Was this reply helpful? Yes No
paul_matthews 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @paul_matthews

Could you please post your expression of Rating Value Label?

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
paul_matthews 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
cdcs 2 on at

Like (0)

Report

.

Was this reply helpful? Yes No
paul_matthews 66 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

paul_matthews 66 on at

Like (5)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No