Logo
banner

Blogs

Filter subgrid based on the lookup field value in Microsoft Dynamics 365 CE

, September 10, 2019 16 Views

Let’s learn today how to filter the sub-grid on a form based on the lookup field value. Below is an example where we will create a sub-grid of a custom entity named “Agents” on the Contact entity form which will display records based on the “Account Name” lookup field value on the Contact form.

For this, first, create a Quick View Form of Account entity by navigating to the Forms under the Account entity and place a subgrid of “Agents” entity on it.

Now, open the form of “Contact” entity and place the above-created Quick View Form on it.

Then, save and publish the customizations and open a Contact record. You will see the list of Agents based on the “Account Name”(Company Name) lookup on the Contact. (i.e.,) List of Agents having the “Account Name” same as that of the Account Name of the current Contact record.

I Hope this helps you!!

 


ATM Inspection PowerApp to ease ATM inspection and report generation process.
https://powerapps.microsoft.com/en-us/partner-showcase/inkey-solutions-atm-inspection/

Insert data into Many-to-Many relationship in Dynamics CRM very easily & quickly, using the Drag and drop listbox.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/drag-and-drop-listbox

Comply your Lead, Contact, and User entities of D365 CRM with GDPR compliance using the GDPR add-on.
https://www.inkeysolutions.com/microsoft-dynamics-365/dynamicscrmaddons/gdpr

Create a personal / system view in Dynamics CRM with all the fields on the form/s which you select for a particular entity using the View Creator.
http://www.inkeysolutions.com/what-we-do/dynamicscrmaddons/view-creator

mm

Inkey

INKEY is your solution partner.
Our focus is to deliver you in-time intelligent innovative solutions ("key") for the problems in hand. Maintaining a quality standard right from the inception of a project is our top most priority.

Our team of talented professionals will execute your projects with dedication and excellence. We take ownership and accountability for the effort that goes into meeting our client’s needs.

Years of experience and proven success of delivering innovative custom solutions.

More posts by

Leave a Reply

Your email address will not be published. Required fields are marked *