Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Open custom dialog that include a filtered sub-grid

Posted on by 873

Hello,

I would like to open a custom page dialog that should include a sub-grid, and the data of the sub-grid will be filtered based on the current record id vs a unique id related from another table.

Example: When I click the below button in the ribbon "Navigate to Ticket" a dialog should appear and show me in the grid the line-items that are related to this account:
Screenshot-2022_2D00_02_2D00_21-173534.png

It is very similar to how we can see the related contacts of the accounts based on the above screenshot, but the only difference is that we're launching a custom dialog onSelect of the button to show the related record(s) in a grid view.

I also thought about another option: (I don't know if it is feasible)

-If the user clicked the Navigate button it will take him directly to the needed table but the question is will it be possible to filter a View dynamically to show only the records that are related to this "Account" that is based on the accountid that I clicked the button from?

Which option is better to achieve the above requirements? Could you please provide an example or some articles that might help?

Any assistance is highly appreciated.

Best regards,
EBMRay

  • EBMRay Profile Picture
    EBMRay 873 on at
    RE: Open custom dialog that include a filtered sub-grid

    Hi  ,

    Thank you for your reply.

    Exactly, but the problem is that we have many tables related to one single table and it will be hard for the user to scroll through all the dropdown options to find the table needed in the related tab.
    That's the reason why we would like to create a custom page or model dialog to display the data in a grid view that will have the same behavior for any sub-grid that is related to a parent entity. In addition, for some tables, we hide the “Related” tab.

    We know that it will require some development efforts to achieve that and we might get back to the system behavior as is to not reinventing the wheel but we want to know what we should leverage to build all this functionality in case we decided to do it that way.

    Looking forward to your response.
    Best regards,
    EBMRay

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Open custom dialog that include a filtered sub-grid

    Hi EBMRay,

    You can view related records easily under 'Related' tab, so why would you want to customize the button?

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,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans