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

Announcements

No record found.

News and Announcements icon
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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 168 Super User 2026 Season 1

#2
NeerajPawar Profile Picture

NeerajPawar 65

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 51 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans