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

Community site session details

Session Id : Vf1+WA1tbXLF9RmizuDACm
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / How to create a view t...
Power Apps - Microsoft Dataverse
Answered

How to create a view that doesnt have related records?

Like (0) ShareShare
ReportReport
Posted on 18 Jun 2020 11:11:31 by Dave Wi

Hello,

 

I have created "Many to Many" relationship between customer and product Entities.

 

Now, I need to display those products which has not related customers, how can I create such view?

 

Thanks,

Categories:
Solution Explorer
Entities
Dataflows
AI Builder
Business Rules
  • Dave Wi Profile Picture
    Dave Wi on 19 Jun 2020 at 11:09:53
    Re: How to create a view that doesnt have related records?

    I did not need to enable the "Search" for many to many relationship at present, the view worked out without that 🙂 You are awesome!

     

    Thank you so much!

     

    Best,

  • Verified answer
    H Sheild Profile Picture
    H Sheild 3,000 Most Valuable Professional on 18 Jun 2020 at 20:01:37
    Re: How to create a view that doesnt have related records?

    Hi @dave8 

     

    You can do this by enabling the "Many to Many" relationship definition to be searchable (see this article for Dynamics CRM - still relevant to Common Data Service today)

    https://gonzaloruizcrm.blogspot.com/2016/09/crm-advanced-find-with-nn-relationships.html

     

    And then you can create a new view where you will be able to see the Many to Many relationship.  For example, here is a the filter condition for a view of Products who do not have a Competitor associated.

    Annotation 2020-06-19 074703.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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans