Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hello guys,here is what I'm going to do:I have a field "Type" and it has option as data type.
As option values I have " ,hybrid,OnPrem,Cloud". Now the users are bothered by the fact that the values are not sorted alphabetically and want the values to be displayed in the selection:" Cloud,hybrid,OnPrem". However, I have many orders in which the field is already filled.Now I need a procedure that allows me to change the option values.If I simply change the order of the options as desired, the result is that the type that was previously "hybrid", for example, is now "Cloud".
The integer value has not changed as a result of the sorting.How should I solve this?
the solution I see as per below
create one more new field as you want with type option and transfer all the data from the old field to new field and of course you need to write a logic in that way the result you want.
after that you can delete the old field
not sure if it’s ok for you
Hi, If the user just wants to sort on selection. You can hide this field on the page.Create a new Option field, for example, B field " ,Cloud,hybrid,OnPrem".
When B validates, A also assigns the corresponding value.
if B = B::Cloud then
A := A::Cloud
In this way, only one page needs to be modified.
Hope this helps as well.
Unfortunately, my logic does not work as I had hoped.
I have now created a new field (ID: 50059) and transferred the value from the old field to the new field via a report.
But now I have a different value in the new field than in the old one (ID: 50053).
How do I have to adapt my logic?
"Service Header"."Worktype 2" := "Service Header"."Worktype";
Hi, Do not assign directly.
Try the following:
if "Service Header"."Worktype" = "Service Header"."Worktype"::hybrid then
"Service Header"."Worktype 2":= "Service Header"."Worktype 2"::hybrid;
Because you have more types, you can use Case statements.
Hope this helps.
Yes Zhu is right here, as also mentioned in my answer earlier please write your logic carefully while transferring the data to new field.
I have now made a new field 2 next to my old field with the non-alphabetically sorted values, whose values are now sorted alphabetically.
With a report I now assign the value from the old field to the new field 2 (OnAfterGetRecord()).
When I run the report, it does not assign the correct value, but the integer value again.
What am I doing wrong?
Use FORMAT function format(yourfieldname::value)
In that way it does not work:
Try using ::'' instead to indicate an empty string
And it is two single quotations marks that should be used - just to be clear on that.
That is also not working.
Then you can try to use the integer value of the option you want to refer to.
The options are zero indexed. So the first option is 0 and so on.
Business Applications communities