Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Marketing emails - Dyn...
Customer experience | Sales, Customer Insights,...
Suggested answer

Marketing emails - Dynamic content - second level relationship

(0) ShareShare
ReportReport
Posted on by SveinS 44

Hi

I'm having a problem solving an issue with dynamic content in an email we want to set up and send out. Part of this email should be fetching data from a second level table, but from what I can find In the documentation this is not supported (https://learn.microsoft.com/en-us/dynamics365/marketing/dynamic-email-content). Is there a workaround for this?

In my case, we have a 'Subscription' table with a 1:N relationship to Contact. A for-each loop is set up to identify the correct record for a specific contact. This is working as it should and I'm able to populate the email with the correctly identified record. This is where it stops for me unfortunately. In addition, there is another table called 'Deal' with a 1:1 relationship to 'Subscription'. I also want to populate the email with a field from this table so the output looks something like this:

Your subscription: <data field from subscription table>

Amount: <data field from deal table>

Relationship between entities:

pastedimage1671009768099v1.png

Thanks in advance for any help with this.

  • Suggested answer
    Haig Liu Profile Picture
    Haig Liu Microsoft Employee on at
    RE: Marketing emails - Dynamic content - second level relationship

    Hi SveinS,

    Outbound marketing emails have a two-hop limit that can't be circumvented,

    My idea is to add a mapped field so that the contact can find the corresponding field directly: 

    Dynamics 365: Mapping Fields - The Marks Group | Small Business Consulting | CRM Consultancy

    Of course, real-time marketing can take up to six hops, and you can also try designing with it.

  • SveinS Profile Picture
    SveinS 44 on at
    RE: Marketing emails - Dynamic content - second level relationship

    Hi, Susanne

    Thanks for the tip. Had a look at the dataset configurations and the table seems to be synced already. At least everything seemed OK according the info in the link you provided.

  • Suggested answer
    Susanne Sauer Profile Picture
    Susanne Sauer 45 on at
    RE: Marketing emails - Dynamic content - second level relationship

    Hi SveinS,

    I had a similar issue recently. I believe it will help you to go to your dataset configuration (or ask your system admin) and make sure that your additional table "Deal" is synced. It basically needs to be "switched on" so that you can include it in your queries.

    Here's the corresponding section in the documentation: Dataset configuration (Dynamics 365 Marketing) | Microsoft Learn

    Hope this helps.

    Susanne

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans