Skip to main content

Notifications

Announcements

No record found.

Customer Service forum

filter subgrid based on another lookup related to it

Posted on by Microsoft Employee

What I need to know is how to filter the sub grid standard solution based on the chosen usecase from above for example Bank. I need only all the standard solution which related to Bank not all the standard solution in subgrid after clicking (+) then (search) button in subgrid.

2crm.PNG

Categories:
  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: filter subgrid based on another lookup related to it

    Hi,

    One possible option is to use quick view, you can simply look related records only in the subgrid : http://himbap.com/blog/?p=3094 this is completely supported !!

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: filter subgrid based on another lookup related to it

    Hi,

    you can refer below blog on how to filter subgrid.but you have tweak a little bit from your side. The demo below was using optionset, and you are using lookup.

    But please note that, this is consider unsupported  because of document.getElementById has been used in this case ( in future it might breaks). So this is your call.

    [View:https://mahadeomatre.blogspot.com/2015/02/dynamically-filter-form-sub-grid-to.html:750:50]

    [View:https://community.dynamics.com/crm/b/nishantranaweblog/archive/2017/05/21/filter-subgrid-in-dynamics-365-with-new-form-rendering-or-turbo-form:750:50]

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans