News and Announcements icon

Power Platform CommunityForums 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?

(0) Share

Report

Report

Posted on 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

All responses Img

All responses (2)

Answers Img

Answers (1)

Dave Wi on at

Like (0)

Report

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 3,000 Most Valuable Professional on at

Like (1)

Report

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Apps - Microsoft Dataverse

#1

stampcoin 15

#2

ankit_singhal 11 Super User 2025 Season 1

#3

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans