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
Solved! Go to 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
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.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi 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
Could you please post your expression of Rating Value Label?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog.
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
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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@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
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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogUser | Count |
---|---|
88 | |
37 | |
25 | |
13 | |
13 |
User | Count |
---|---|
121 | |
55 | |
36 | |
24 | |
21 |