Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Field Service forum / Multi Select Lookup Fi...
Field Service forum
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

Categories:
Administration
Analysis and Integration
Connected Field Service
Other
  • 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,068 Super User 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)

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans