Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / How to filter records ...
Sales forum
Suggested answer

How to filter records in the NToNMultiSelect control field?

Posted on by 50

On the Product form I have "Product type" field (option set: product or package) and "Product category" field (NToNMultiSelect control). Product Category is an entity, that have a relationship with Product. Each Product Category has boolean fields like "valid for product" and "valid for package". And if the category is valid for product, it has to be shown in the NToNMultiSelect control on the Product form. othewise no. 

  • Suggested answer
    Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,498 Super User 2024 Season 2 on at
    RE: How to filter records in the NToNMultiSelect control field?

    Hi Maria,

    You can add a subgrid on your form that displays the related records of your product.

    You can follow this link to display related Records (N-N)

    community.dynamics.com/.../displaying-sub-grid-for-second-level-relationships

    Hope that's helpful for you.

    Please mark the answer as verified if that's resolve your issue

  • UDS Systems Profile Picture
    UDS Systems 50 on at
    RE: How to filter records in the NToNMultiSelect control field?

    Product Category is a custom entity.

    I want to see in Product category field (on the Product form) only records which are related with a product type. I have only two product types: product and package, and if Category is valid for this type (I have two boolean fields on the Category form, like "valid for product" and "valid for package") then I want to see it in my Product category field which is on the Product form and has NToNMultiSelect control.

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 5,816 Moderator on at
    RE: How to filter records in the NToNMultiSelect control field?

    Hello Maria,

    Can you provide more information about the product category entity? like is it custom entity or OOB entity ? and what you want to implement ?

    Thank you,

    Amit Katariya

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans