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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Sorting OptionSet base...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Sorting OptionSet based on Label

(0) ShareShare
ReportReport
Posted on by PS10 8

Hi, 

We have an option set field with Label and Values as: Medium(0), Low(1) and High(2), when showing this option set on chart they come up in random order and client wants to show them in order of priority like: High, Medium and Low. 

If i change the values like (High(0), Medium(1) and Low(2) to show in the correct order i know this will sort my order but issue is it will then muddle up the data in Production due to change of labels which was High before will be now Low etc..

What is the best way to sort chart based on Labels or if i change the values how to the correct the data mapping?

Thanks,

PS

I have the same question (0)
  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at

    Hi,

    You can't do that but to implement your requirement you can do what you are doing and update your existing data using new order so that all the data will be in the correct format.

    You can follow below steps:

    1. You can create a dummy txt field in your entity to hold old value

    2.  Go to Advaned Find, add your old field and new field and add condtion where your old field contains data, export it.

    3. Copy old field value to txt field (so old field labels will be copied  to new field)

    4. Import this list back to CRM

    5. Modify your old field and change order

    6. Export same excel again and now copy value from txt field to your option set field,

    7. Reimport it back.

    Now you will have correct order and all the existing data is updated.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 202 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans