Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Field Mapping

(0) ShareShare
ReportReport
Posted on by 8

Hi, 

Created new Field mapping for a two option set field between Lead->Contact. 

Problem is that for existing records it is not going to work since all Lead records are inactive and do not carry any default value and hence all existing contacts value is blank as well and is prompting  to save the record. 

Is there a quick way to default and save all these existing contact records with the right value. 

Thanks,

PS

  • LuHao Profile Picture
    LuHao 40,874 on at
    RE: Field Mapping

    Hi partner,

    On your second question.

    Yes, if the field is set to read-only on the form, it will not allow updates in th workflow.

    So I would recommend you first remove this field form the form, then run the on-demand workflow for records of the view, finally add this field back on the form after successful execution.

  • LuHao Profile Picture
    LuHao 40,874 on at
    RE: Field Mapping

    Hi partner,

    I would recommend you post both issues as separate threads.

    This will allow other experts to participate in the discussiona and it will also facilitate forum users to navigate to precise threads.

  • PS10 Profile Picture
    PS10 8 on at
    RE: Field Mapping

    Hi,

    I was doing import/Export to solve the issue but your solution is better and easier, but i was hoping that using your solution it will also help me with the below two related issues:

    1)Since this mapping field is expected to have a value, all existing Contact records are showing unsaved changes and after clicking save one time record works just fine as expected, but ideally when i am updating this option set all records should remain in saved state. Is there a way to bulk save these records?

    2) Workflow is not allowing me to update the option set which is read only on the form, is that a restriction? If yes, then i will have to go back to my import method for this two option set field.

    Thanks,

    PS

  • Verified answer
    LuHao Profile Picture
    LuHao 40,874 on at
    RE: Field Mapping

    Hi partner,

    We will use the on-demand workflow and the "Bulk Workflow Execution" tool of XrmToolBox to update contacts in bulk.

    First refer to these two documents to know how to create a workflow.

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/workflow-processes

    https://crmbook.powerobjects.com/system-administration/processes/workflows/

    Create such a workflow.

    Check As an on-demand process, select Scope as Organization. Add Step: Update Record.

    pastedimage1583149793466v1.png

    Select Update: Contact. Click Set Properties

    First select a value of two option set field, then at Form Assistant, select Originating Lead (Lead), then select lead's two option set field, then OK.

    pastedimage1583150036863v3.png

    Activate this workflow.

    If there are many existing contacts that need to be updated in your environment, then we need to use the "Bulk Workflow Execution" tool of XrmToolBox to update all contacts at once.

    This is the download page for XrmToolBox: https://www.xrmtoolbox.com/

    After downloading and unzipping it, open XrmToolBox.exe.

    Install Bulk Workflow Execution in the tool library. Connect to your D365 organization.

    With Bulk Workflow Execution open, select the workflow and the contact view. Click Validate Query first, and then click Start Workflows.

    In this way, all contacts in this view will be updated according to the selected workflow.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans