Hi Guys,
I have two entities. i create relationship between two entities and add lookup field to one entity but in my requirement i want to change my lookup field to optionset type. It is any possibility is there for change lookup to optionset. anything is there means please tell me guys
Thank You
*This post is locked for comments
Hi Dinesh,
We cannot modify the field data types after creation. so the only option you left with creating a new optionset type field. if you are concerned about data then, you can just create a ondemand workflow and map the data accordingly. then you may execute the workflow upto 250 records at a time (from advancefind/homegrid) or if you have many more then you can run the workflow through a simple console
Share
Report
All responses (
Answers (
// Create an ExecuteWorkflow request.
ExecuteWorkflowRequest request = new ExecuteWorkflowRequest()
{
WorkflowId = _workflowId,
EntityId = _leadId
};
Console.Write("Created ExecuteWorkflow request, ");
// Execute the workflow.
ExecuteWorkflowResponse response =
(ExecuteWorkflowResponse)_serviceProxy.Execute(request);
Console.WriteLine("and sent request to service.");
Increase number of records per page - https://arunpotti.wordpress.com/2015/08/12/increase-number-of-records-per-page-in-ms-crm/
sample code link - https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/sample-run-workflow
Hello,
Mainly you cannot do it from the D365, you have to delete the field and recreate it; However, you can always try the plugin "AttributeManager" of the XrmToolbox that is used to rename/delete/or change the type of an attribute: www.xrmtoolbox.com/.../DLaB.Xrm.AttributeManager
Unfortunately there's no way to change the data type of a field once it's been created. If you have existing records that use the lookup and you want to capture that in an optionset, your best bet is to create the optionset field and then run an SSIS package to map the lookup values to optionset values. Then you can delete the lookup field
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156