Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Add subgrid data in a view

(0) ShareShare
ReportReport
Posted on by 50

Hi,

I have a Portal where I have the following scenario:

Contact entity has a column Manager that is a lookup (Company) to Account entity. So, I create a contact ABC and under the field Company, I want to enter Costco, Walmart and Target.

Then user ABC logs in the Portal and want to submit a claim form(Created in Claims table). So, when he search for the company (ex. Costco) he wants to submit claim for, he should see Costco, Walmart and Target and should be able to select Costco from three options.

So, essentially, I am using three tables in this use case: Contact, Account and Claims.

To achieve this I add a subgrid to the Contact table and use that subgrid in the claims form so that user can see Costco, Walmart and Target in the Company field to select one. Now, I am trying to have a view on the Portal landing page where the user should be able to see all the claims submitted for Costco, Walmart and Target. The view should have a column "Company Name" that has the values Costco/Walmart/Target.

How can I get this view?

Thanks

  • learnincommunity Profile Picture
    50 on at
    RE: Add subgrid data in a view

    Thanks Steve.

    How can I have a subgrid in a view? And a subgrid from one table in another?

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Add subgrid data in a view

    Hi learnincommunity,

    You can create a list in your portal to show that view's data.(If you don't know your view name, you could open your subgrid to get it.)

    Here is a blog about how to creating list in the portal:

    softchief.com/.../

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,272 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,931 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans