cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to retrieve an option set label

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.

 

optionset value.jpg

 

Thanks for your help

Paul

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

 

optionset value.jpg

 

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

View solution in original post

12 REPLIES 12
Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted

Hi abm

 

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

 

optionset value2.jpg

 

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

Highlighted

Hi @paul_matthews 

 

Could you please post your expression of Rating Value Label?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted

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

 

 

Highlighted

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Regular Visitor

.

Highlighted

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

Highlighted

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

 

optionset value.jpg

 

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

View solution in original post

Highlighted

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Kudo Commander
Kudo Commander

@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

Highlighted

Hi @LinnZawWin 

 

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

 

Thanks

Paul

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,909)