cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paul_matthews
Advocate I
Advocate I

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

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

20 REPLIES 20
abm
Most Valuable Professional
Most Valuable Professional

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

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

abm
Most Valuable Professional
Most Valuable Professional

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
abm
Most Valuable Professional
Most Valuable Professional

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

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
Most Valuable Professional
Most Valuable Professional

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
cdcs
Regular Visitor

.

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

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

abm
Most Valuable Professional
Most Valuable Professional

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
LinnZawWin
Multi Super User
Multi Super User

@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

Hi @LinnZawWin 

 

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

 

Thanks

Paul

powerwood
Helper IV
Helper IV

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?

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

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
Most Valuable Professional
Most Valuable Professional

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



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

is "_leadqualitycode" your schema name or logical name?

@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.

 

 

 

@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

Helpful resources

Announcements

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (4,719)