Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

How do I set the value of a Client on a case based on the Sender of the Email?

Posted on by Microsoft Employee

Hi,

When an email is sent it a case is automatically created. How to I set the client value to the account of the email sender.

At the moment it is being stored in the customer field. I want to store it in the client field.

Please help.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I set the value of a Client on a case based on the Sender of the Email?

    Hi cam64,

    You can add another action--update Record--Create(Case),  update the field you new created with value from customer.

    pastedimage1629877440524v1.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I set the value of a Client on a case based on the Sender of the Email?

    Thank you for your reply.

    I can't seem to be able to open the power automate. My setting is still in the classic UI. I think. 

    Screen-Shot-2021_2D00_08_2D00_24-at-11.01.20-pm.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I set the value of a Client on a case based on the Sender of the Email?

    Hi cam64,

    The case is created through Automatic Record Creation and Update Rule, you can open the power automate to edit the flow.

    pastedimage1629782449469v1.png

    In power automate, you can copy value that filled in customer field and paste to the new field you created.

    pastedimage1629782533178v2.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I set the value of a Client on a case based on the Sender of the Email?

    Thanks for your reply.

    Everything you mentioned is correct. I think the assignments happen OOTB. My question is how do you set a field with the value of the Client of the sender.

    I created a field that will store this information. I just need to find the correct field and set it in the Automatic record creation. But I can't determine which field and from what entity.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do I set the value of a Client on a case based on the Sender of the Email?

    Hi cam64,

    Unfortunately, you can't achieve it.

    The Customer field on the case entity have two types—Account and Contact.,which is a required field, and you can’t make the customer field non-required.

    pastedimage1629773471758v2.png

    And the Contact lookup field on case entity is based on the value of the customer filed.

    --If the Customer value is Account, the contact field can only show related child contacts of the Account.

    pastedimage1629773872568v3.png

    --If the Customer value is Contact, the contact can’t be filled with any value.

    pastedimage1629773884114v4.png

    Or you can copy value from customer field, but OOB contact field on case entity can't store the value.

    Maybe you can create a new 1:N relationship between contact and case entities, and add the new contact lookup field to the case form.

    Then you can create a workflow to update the new contact lookup field with value from the customer field

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans