Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer Service forum / Is there a way to add ...
Customer Service forum
Suggested answer

Is there a way to add subgrid columns to a view from another entity (N:1 relationship)?

(0) ShareShare
ReportReport
Posted on by SivaR 459

Hi,

I have N:1 relationship between Organazation and Brand names (one organization can have many brand names).

In the organization form, i have a subgrid to add brand names. 

Requirement is: 

User needs to be able to search and sort on individual Brand names from Active organizations view?

Since the Brand name comes from a child entity (Brand name entity), i won't be able to see in the organization entity to add a column to a view.

How i can add brand names to the organization view?

Thank you,

Siva

 

Categories:
Case Management
  • SivaR Profile Picture
    SivaR 459 on at
    RE: Is there a way to add subgrid columns to a view from another entity (N:1 relationship)?

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/230898/how-to-update-a-field-based-on-the-subgrid-data/628977

    this link helped me to achieve what I was looking for.

    thank you,

    Siva

  • SivaR Profile Picture
    SivaR 459 on at
    RE: Is there a way to add subgrid columns to a view from another entity (N:1 relationship)?

    Thank you Charan,

    I checked the following link. community.dynamics.com/.../701407

    is it possible to create a new field in organization and  run workflow to update a new field with concatenated selected brandnames with N:1 relationship?

    How to check if the subgrid values (brand names) changed to run a workflow

    Regards,

    Siva

  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Moderator on at
    RE: Is there a way to add subgrid columns to a view from another entity (N:1 relationship)?

    Hi Siva,

    If I have understood your requirement correctly, you need to search Organization records by Brand Name under Active Organizations main grid view where, one Organization can have multiple Brand Names. This is not possible unless you store all brand names in one of the text field on Organization entity and add this column as a find column under Quick Find View. System allows to add find columns only from current entity, not from related entities.

    For viewing, only current entity and parent entity columns can be added to the view, but not from the child entity.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans