Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Multi Select Lookup Fi...
Service | Customer Service, Contact Center, Fie...
Answered

Multi Select Lookup Filtered

(0) ShareShare
ReportReport
Posted on by Catalinas 20

Hi, is there a way to filter a Multi Select Lookup field by other? For example:

pastedimage1668011616685v1.png

I want to filter the "Subcategoría" by the "Categoría" and both fields are Multi Select Lookup Control

  • Suggested answer
    leonardo_1711 Profile Picture
    leonardo_1711 2 on at
    Multi Select Lookup Filtered
    Hey there user,
     
    There is actually a solution now. 
     
    How you achieve it is :
     
    Say you want Subcategories and Service Families filtered by category.
     
    1. You would need a regular lookup field of the entity contained in your multiselect lookup control.
    2. A text field named DefaultViewKey.
     
    Then on your Javascript you can use the addCustomView on your regular lookup field, then set the view ID to the Default View Key. In parallel, the default view id for your multiselect lookup control should be pointing to the field we created in step 2.
    You can hide both the above fields, and the default view for your multiselect lookup field, will now be the one you defined for the regular lookup fields.
     
    Let me know if you need more help with it.
     
     
  • Verified answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Multi Select Lookup Filtered

    Hi Catalinas,

    In case filtration is not available on the multi-select option set. You can achieve your requirement using custom many-to-many relationships. In your custom table responsible to maintain the many-many relationships. You can filter a lookup on the basis of another lookup using related filter functionality on the main form. I think it is a good workaround for you.

  • Suggested answer
    Steve Zhao2 Profile Picture
    Steve Zhao2 on at
    RE: Multi Select Lookup Filtered

    Hi Catalinas,

    Unfortunately, there is no OOB way to filter Multi Select Lookup Control. And I also try JS to achieve this. However, Multi Select Lookup Control doesn't support  addCustomFilter.

    You could submit an idea here to progress this feature:

    Categories (dynamics.com)

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

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans