Skip to main content

Notifications

Announcements

No record found.

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

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans