web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to get translated option sets to alphabetical order?

(0) ShareShare
ReportReport
Posted on by 45

Hi Community!

I've tried to find an answer to my question about option sets. The situation is that I have CRM 2016 Online with English and Finnish languages and I'd need the option sets to arrange alphabetically despite of the language user uses. For example when user chooses Country from a drop down list (global option set) s/he would see the countries in alphabetical order despite of s/he is using English or Finnish in her/his CRM.

Now the option set is arranged alphabetically by English country names and when a Finnish user sees the list the country names are in Finnish but ordered by the countries' English names. Is there any way to sort the list alphabetically despite of the language i.e. for English speaking users the list would sort by countries' English names and for Finnish speaking users the list would sort by countries' Finnish names?

Thanks for the answer!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alagunellaikumar Profile Picture
    6,212 on at
    RE: How to get translated option sets to alphabetical order?

    Hi

    In CRM OOB it is not possible But you can customize through javascript  Please refer below for dynamic value change in optionset

    alagunellaikumar.blogspot.in/.../dynamically-add-and-remove-value-in-crm.html

  • Josh Hoy Profile Picture
    5 on at
    RE: How to get translated option sets to alphabetical order?

    Thanks both!

    5+ years later, and we're facing the same issue. We have a PowerApps Portal with an Entity List including an option set (choice). We have a translation for the labels but when sorting on the column in another language (French), the column sorts on the base language (English) label values. The the same behaviour exists in CRM.

    To the best of my knowledge there's still no OOB way to resolve this issue, as Alagu mentioned. Here's a link to vote for this enhancement on Power Apps Ideas:

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Option-Set-sort-order-should-be-language-related/idi-p/219925

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans