Skip to main content

Notifications

Customer Insights - Journeys forum

Can 'From Email' be a lookup field?

Posted on by 545

I am trying to personalize the From Address for a marketing email.  I want it to be the Contact's Owner's Email.  I cannot find this field in the option list.  I have a few ideas on why this would be:

1. Is it because this is a lookup field?

2. Is it because this field is not displayed on the Contact form (only Owner Name is)?  So if I add it, it will appear?

3. Is it because it is part of the Owner/User entity which cannot be accessed from the Relationship option list?

Appreciate your help!

Categories:
  • Stephani Profile Picture
    Stephani 545 on at
    RE: Can 'From Email' be a lookup field?

    Thank-you, Karl - this resolved the issue!  I assumed (which was wrong) that the User entity was already sync'd because it was referenced in the documentation.  I assumed it was sync'd as part of the install of the Marketing app.  It was NOT.  The fields and entity became available once we sync'd it.

  • Verified answer
    Karl Maybach Profile Picture
    Karl Maybach on at
    RE: Can 'From Email' be a lookup field?

    You should be able to do this, but it could be that you haven't yet synced the required entity to make it available for use in email dynamic content:

    1. If your Marketing instance isn't already set up to sync the User (systemuser) entity with the marketing insights service, talk to your admin about setting this up. If you are the admin, then see Choose entities to sync with the marketing insights service for instructions.

    Once that entity has synced (allow about half an hour), you should be able to choose the required relation. However, I can see the relation display name has changed slightly since that documentation was written. It is now "Owning User (Contact) -> User" rather than "Owning User systemuser (Contact) -> User". The following should work to create the required expression:

    pastedimage1568970818093v1.png

    . Karl

  • Suggested answer
    megcda Profile Picture
    megcda 2,192 on at
    RE: Can 'From Email' be a lookup field?

    Hi Stephani,

    Lookup fields aren't supported for dynamic content at this time.  I suggest putting in a feature request on the Marketing Ideas portal as community upvoting influences our roadmap.  I know that this is in the backlog but community support will help get it prioritized.  

    Thanks,

    Megan

    Please mark as Verified if this answers your question.

  • Stephani Profile Picture
    Stephani 545 on at
    RE: Can 'From Email' be a lookup field?

    I tried the steps in this article and do NOT see the related entity it references.

    docs.microsoft.com/.../dynamic-email-content

    Delete the contents of the From address field and then select the Assist-edit button  next to this field.

    On the first page of the assist-edit dialog, select Contextual and set it to Contact. Then select Next.

    On the second page of the assist-edit dialog, select Related entity and then:

    Set the top drop-down list (relationship) to Owning User systemuser (Contact) -> User.

    Set the bottom drop-down list (field) to Primary email.

    Select OK to place the expression, which should be: {{contact.contact_systemuser_owninguser.internalemailaddress}}.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans