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

Creating segments with Tables from Power Apps?

(0) ShareShare
ReportReport
Posted on by 35

Title says it all.  Our marketing contacts are grouped by a number of look up values. I'd like to drill down by values in a number of look up tables. Must I start with Contact and then query from a foreign key in the contact table?.   

  • Suggested answer
    Petit Hibou Profile Picture
    on at

    Hi Jarthda,

    If this is Marketing Segmentation Query builder question,

    - you can either start or end with Contact

    - lookup values should be marked for sync in Application Settings.

    Br

    Elena

  • Community Member Profile Picture
    on at

    Hey,

    Like mentioned before, there are multiple ways to achieve the same result. There is not really a good/bad way in my opinion. I've added an example below to make it more tangible:

    pastedimage1614603899615v1.png

    Here you can see that I have a separate custom entity called 'systems in place' (N:N).(not directly related to a contact). This entity is used to track what software solutions a company currently has and that we integrate with. So in the above example I first specify the 'systems' i want to filter (Microsoft POS). This is linked to the account in the second step (you can only select related entities). I add an additional filter to the account entity to only segment accounts with Microsoft POS as a base system and that are based in the United States of America (this is again a custom entity with a N:1 relationship to select the country from a list). However, my segment is still not finished, because I have to target contacts. So the final step is to somehow link my contact. In this case I do this by selecting all contact that belong to accounts with the above criteria. 

    I can achieve the same result by starting form the contact and then start selecting related entities:

    pastedimage1614604352192v2.png

    (I prefer the fist method, because I think it looks cleaner and our users seem to adopt this better.)

    If your entity isn't available for selection you need to make sure that the entity has relevance search turned on and is synced with the marketing application: 

    1: settings --> dataset configuration --> select the entities to sync

    pastedimage1614604477845v3.png

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daniyal Khaleel Profile Picture

Daniyal Khaleel 103 Most Valuable Professional

#2
11manish Profile Picture

11manish 69 Super User 2026 Season 2

#3
Travis South Profile Picture

Travis South 50

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans