Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Is there a way to add ...
Service | Customer Service, Contact Center, Fie...
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

 

  • 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 Super User 2024 Season 1 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.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans