Answered

Get OptionSet value in different language

(0) Share

Report

Posted on by MTR_RuF

Within a flow I want to get the label text from an OptionSet.

I've found following ressource which describes how to use the CDS connector to get the text: https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html

I get the label always in English language - even though I changed settings to German - see this hint https://powerusers.microsoft.com/t5/Using-Flows/How-to-change-language/td-p/755573.

Any idea how to get the label from an OptionSet in a different language using CDS connector?

All responses (5)

Answers (1)

MTR_RuF 43 on at

Like (0)

Report

Re: Get OptionSet value in different language

Thank you - that does the trick!
For whatever reason that did not come to my mind at all.

(still it seems to me more robust if I could set the language within my flow itself)
Verified answer

Expiscornovus 32,047 Most Valuable Professional on at

Like (1)

Report

Re: Get OptionSet value in different language

Hi @MTrummer,

Are you using the Translation feature of Dynamics? If not, you could translate the options set labels for those other languages as a workaround. This is a short YouTube video about that process:

How to Add Translations for Custom Fields and Entities in CRM 2013

When the translations are imported and published you should be able to choose that other language also for the account used for the flow connections.

Be aware, everything for that account will be translated into German.

The custom options set labels should now also be presented in the different language for that specific user (in this case German).

When you retrieve the data within a Power Automate flow with that same user account it should also retrieve the German labels.
VIDIT 666 on at

Like (0)

Report

Re: Get OptionSet value in different language

Yeah @MTrummer I do agree to what you said.
MTR_RuF 43 on at

Like (0)

Report

Re: Get OptionSet value in different language

Thank you for this idea.
I understand your approach - but that means I'd need to maintain the labels in two places (D365 CRM and Power Automate). As I do have a lot of OptionSets this is not really an option and error prone in worst case.

I can't believe that this is supposed by Microsoft to be done this way.
And the requirement does not seem to be very special - does it?
VIDIT 666 on at

Like (0)

Report

Re: Get OptionSet value in different language

Hi @MTrummer you can try this instead this is how I do it
I have an Option set with values as below
Now Check my flow and see the magic
so what I did here is I created a json of the option set values and the corresponding label as as shown in the below flow
Step - 1 Create json as below with your values and labels
Step -2 Create a string variable and set its value to your option set value from dynamic contents.
Step - 3 Use the below expressions in the place where you want the label value to appear

Output -
Hope that helps !
Let me know incase any issues.
If this resolves your issue please mark this post as answered and hit me a thumps up.
Thanks and Regards,
Vidit