Include 1:N Data in Personalized RTJ Email Content

(1) Share

Report

Posted on by A.Serie

I am attempting to set up an email in Real Time Journeys that needs to include personalized content from a 1:N relationship. Scenario is, 1 contact, numerous donation requests. We'd like to pull information from the contact's related donation requests.

In outbound marketing we had this email set up using this #each statement logic, as mentioned here: Using personalised content with multiple bookings under one contact (dynamics.com), but this logic does not seem to work in RTJ. I get warnings saying that my expression is too many hops away.

When looking through the standard personalization tool, it appears that I can select the Donation Requests relationships and the fields of data I need, however, when testing this out, it only pulls in one of the related record's information, not all of them.

Is it possible to pull in 1:N data into RTJ? Not available yet? Here's another article I've reviewed, but again seems specific to outbound emails only: Add dynamic content to email messages - Dynamics 365 Customer Insights | Microsoft Learn

All responses (2)

Answers (1)

A.Serie 61 on at

Like (0)

Report

Include 1:N Data in Personalized RTJ Email Content

This is exactly what I was looking for, thank you!
Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Include 1:N Data in Personalized RTJ Email Content

Hi,

Your ideas can be implemented by the Personalize lists.
Personalize lists of content in emails - Dynamics 365 Customer Insights | Microsoft Learn

The example is as follows.
The Contact table has a 1:N relationship with the Connection table.

This contact has two connections.

Set up the Personalize list in the email to show all the connections of the contact.

In the preview test results you can see that the Personalize list shows all the connections of the contact.

After sending via Journey, the body of the email is displayed as follows.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li