Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

insert value to choice column

Posted on by 112

Hi !

I would like to insert a single value from Lead form Ownership to Account Ownership choice column, but cannot do it.

Thanks a lot

HarHar

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Leah,

    Bingo, its done !

    I have created a process for Sync those field, it work.

    The screenshot as follow:-

    Appreciate your great help.

    HarHar

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Leah,

    Thanks for quick response.

    I have set only one choice field, both fields are the same but when I save or quality the record, it cannot Sync to the account table.

    Need to set the Sync somewhere to update the record from Lead to Account ?

    Appreciate your great help.

    Har Har

  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: insert value to choice column

    Hi HarHar,

    Did you create two global options?

    From the screenshot in your previous reply, I see that you have selected two different global choice for the two fields in Account and Lead, because the value of 'Sync with choice with' is not the same:

    You should create only one global choice field, and then both fields on the account and the lead should come from this one global choice.

    This means that the value of 'Sync with choice with' should be the same.

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Linn,

    Good morning,

    It is a global choice, I have tried global choice and local choice, both not allow to set the value.

    Thanks

    HarHar

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: insert value to choice column

    What is the logicla name of the "Relationship Type" column? If it's the local Choice (not global choice), I guess you'll have to set the value of it using the Power Automate cloud flow and you won't be achieve with the classic workflow.

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Leah,

    Having try other table, still cannot allow to set any update to choice column "Relationship Type".

    Appreciate your great help.

    HarHar

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Leah,

    Thanks for quick response.

    I have follow your instruction, but the choice column field cannot allow to set any update ?

    Any idea of it ?

    Appreciate your great help.

    HarHar

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: insert value to choice column

    Hi HarHar,

    When you create lead to select an existing account, are the existing account fields populated manually?

    If so, you can try to create one workflow to update it automatically.

    --Go Settings > Process, create the workflow on the Lead entity:

    --Trigger:

    --Steps:

    (1)Condition

    (2)Update account

  • HarHar Profile Picture
    HarHar 112 on at
    RE: insert value to choice column

    Hi Leah,

    Good afternoon, Thanks for quick response.

    The Account record has been created from the Account form, it is an existing record.

    Need to update the "Relationship Type" value to the Account form when a Lead was created.

    That means update the transaction record value to master record value.

    In this case, the mapping may not be work, any other way just to do so ?

    Appreciate your create help.

    HarHar

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: insert value to choice column

    Hi HarHar,

    How did you create the Account in the beginning?

      

    Populate company details and click 'Qualify' button, one account can be created automatically.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans