Skip to main content

Notifications

Service | Customer Service, Contact Center, Fie...
Answered

Multi Select Lookup Filtered

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans