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,...
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?.   

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: Creating segments with Tables from Power Apps?

    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

  • Suggested answer
    Petit Hibou Profile Picture
    on at
    RE: Creating segments with Tables from Power Apps?

    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

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 184

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 126 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans