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

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Creating Segment Based On Lookup Contact's Fields

(0) ShareShare
ReportReport
Posted on by 2
Hi all, I've been using Outbound Marketing for segmentation, and now gradually transit to Real-time Marketing (CI - Journey). However, I've got complicated use case that seems cannot be achieved in the Real-time Marketing segment builder.
 
Background: Let's say there are two contacts in the Contact entity, Contact A and Contact B. Contact A and Contact B are related by a record in the Contact Relationship entity. For each record in the Contact Relationship entity, there are two contact lookup fields and one text field indicating the relationship between the two contacts.
 
Use Case: I would like to target contacts with Last Name = /John/ which has a relationship record associated with another contact with Last Name = /Sam/. In Outbound Marketing, it can be achieved with the below set up.
 
 
It would be very appreciated if someone could help me out with that, thank you!
I have the same question (0)
  • Verified answer
    Leah Ju Profile Picture
    Microsoft Employee on at
    Creating Segment Based On Lookup Contact's Fields
    Hi Partner,
    Currently, we can't achieve it in the RTM segment.
    But we can use segment from OBM in the RTM journey:

    I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
    Regards,
    Leah

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 117 Super User 2025 Season 2

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 110

#3
#ManoVerse Profile Picture

#ManoVerse 56

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans