web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
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

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.

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    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
    on at

    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

  • Suggested answer
    Community Member Profile Picture
    on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 41

#2
Martin Dráb Profile Picture

Martin Dráb 36 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans