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:
Thanks in advance for any help with this.
