Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Created a System View that is not visible in advance find

(1) ShareShare
ReportReport
Posted on by 22
We have created a system views but that is not visible  in advance find.
The view that we created  contains a filter like related entity (XYZ )does not contain data. 
Entity Account is having many to many relation with the entity XYZ. 
  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 9,949 Super User 2025 Season 1 on at
    Created a System View that is not visible in advance find
    Advanced find will show 1:N relationship.
     
    If you need to add some conditions regarding to the N:N relationship then you will have to use 3rd party tools like fetchXML builder or REST builder, because advanced find will not show this relationship.
     
    Please let me know if you need any more information about the tools and more details.
  • Suggested answer
    Ali Hamza Profile Picture
    Ali Hamza 79 on at
    Created a System View that is not visible in advance find
    Hi, 
    I think you are referring to Advance Settings -> Advance Find. Now there you need to select the respective entity like Account in this scenario. 
     
     
     
     
    Then we have Advance filter as shown below. 
    I believe the view you have created, its not Published. Therefore please do below. 
     
    1) After creating the view, click on Save & Publish in Power Apps view editor window.
    2) To be on safe end you can Publish whole Account table or Publish All Customization from your solution
    3) My be Advance find is not properly refreshed. So hard refresh by pressing Shift + R on windows.
    4) In Advance Find, go to Account entity and find your view.
     
     
     
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 203 on at
    Created a System View that is not visible in advance find
    The view looks like it should be visible under the Account table. There are a few things to check.
    1.  Did you publish the Account table after creating the new system view?
    2.  Do you have a custom model driven app, where maybe the view is not being added to the app and is thus not available? (Create, add and remove forms, views, or charts in a model-driven app using the app designer - Power Apps | Microsoft Learn)
    3.  Is the view visible in the legacy advanced find window? If you open CRM and go to Advanced Settings > Then open advanced find it will use the legacy window that should include all system views, regardless of what is in the app (Create, add and remove forms, views, or charts in a model-driven app using the app designer - Power Apps | Microsoft Learn)
  • CindyHaast2205 Profile Picture
    CindyHaast2205 28 on at
    Created a System View that is not visible in advance find
    Hi,
     
    Many to Many relationships are unfortunately not offering the same search results as a N-1/N-1 relationship would. This is because the system intersect table is not directly accessible in Advanced Find.
     
    For this reason I recommend to build your solution with a manual intersect table. You can then run your advanced query. The intersect table would contains look ups to both table, but also from a future scalability perspective it potentially allows you to add additional columns in the future.
     
    As an example - A Contact can go to many Events, and an Event can be attended by many contacts == Many to Many
    But now we create a manual intersect table called "Contact at Event" with a look up to the contact and a look up to event.
    Then we can add other information in the future if needed. for example, who could have foreseen that you needed to do a COVID test everytime you wanted to go to an event - So the new table can be configured to include new fields to capture date of covid test, and covid test result for example.
     
    If it is too late to create a manual intersect entity - then you can also write a custom FetchXML query. Or possibly a Power Automate query that that flags TABLE1record with no related XYZ records and adds that flag to a custom field on the table 1. You can then filter by this field in Advanced Find.

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans