Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

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

(0) ShareShare
ReportReport
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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans