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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Email personalisation - List of records that appear in a related entity.

(0) ShareShare
ReportReport
Posted on by 65

Good afternoon,

What im aiming to do is on the sending of an email (either in real time or outbound) - It uses the contact to lookup against a table called "Application Status" and pulls back all of the applications that the person has with my company. 

As an additional to this - the next level would then be that I can filter those applications by status i.e. if "status" eq "accepted" OR "Pending" then it returns those results and not the ones that don't fit that criteria. 

I tried to use the personalisation on Real time marketing but it told me I had to use a specific record for the personalisation and it wont return the list of related records. 

Any help is appreciated. 

Cheers, 

I have the same question (0)
  • Haig Liu Profile Picture
    Microsoft Employee on at

    Hi JoshDB,

    I have an idea: use the lookup view to filter out the records,

    Send it out as a table in the HTML of an email, which can be done using power automate,

    but not in marketing.

  • Suggested answer
    Vinayd-MSFT Profile Picture
    Microsoft Employee on at

    If I understand the scenario correctly, you have 1:Many relation between Contact and Application status and you want to include information from the Application Status tables for only those related records that meet certain conditions. This would be "Filtered list" - we recently released this feature in preview. Please see New and upcoming features (Dynamics 365 Marketing) | Microsoft Learn for December release sub-section “Fine-tune email communications with filtered lists

    Let us know if this meets your needs. Thanks

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

News and Announcements

Season of Giving Solutions is Here!

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 > Customer experience | Sales, Customer Insights, CRM

#1
Pallavi Phade Profile Picture

Pallavi Phade 101

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 66 Super User 2025 Season 2

#3
TAHER Mehdi Profile Picture

TAHER Mehdi 58

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans