web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Portal to fetch accoun...
Power Pages
Suggested Answer

Portal to fetch accounts linked to the contact

(1) ShareShare
ReportReport
Posted on by 4
I wanted to link Multiple accounts to a Contact, and when we login to portal using the contact it needs to fetch the linked account details.
 
I tried by creating custom relationship between Account and Contact but it didn't allow me to link multiple account to a contact, Anyway to achieve this .As a portal user I should be able to pick both the Accounts data.
Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,479 Super User 2025 Season 2 on at
    Is this a D365 question or a Graph API question?
  • PG- Assistant Technical Consultant Profile Picture
    13 on at
    Hi

    🔹 Use a Custom Many-to-Many (N:N) Relationship

    • Create a custom relationship between Contact and Account.
      • Table 1: Contact
      • Table 2: Account
      • Relationship type: Many-to-Many
    • In the Contact form in Dataverse, you can now add multiple Accounts.

     

  • Suggested answer
    Fubar Profile Picture
    8,354 Super User 2025 Season 2 on at
    You need to establish an appropriate relationship in dataverse e.g. many-to-many between Contact and Account tables.
     
    Create a Table Permission for the new relationship between Contact and Account (scope will be contact or parent/child)
    Add the new Table Permission to the Web Role that the portal user is using.
     
    Create a Web Page with a List of Accounts, with the appropriate table permissions this should display the list of accounts for the Contact (portal user)
     
     
     
     
  • VP-27060416-0 Profile Picture
    4 on at
    @Fubar
    I have created many to many relationship between Contact and Account. when i try to relate Contact with a Account getting error stating The record cannot be related as it already has a Parent Account
  • Suggested answer
    Fubar Profile Picture
    8,354 Super User 2025 Season 2 on at
    When you say relate the Contact and Account is this in Model Driven App or from Power Pages?
     
    If in Model Driven App, it sounds like you may be trying to use the out of the box Company Name (parent account) field on the Contact which is a one-to-many. For your Many-to-many relationship you need to add a new Subgrid to the Contact (and also may want a subgrid on Account if you want to see/add the contacts from the Account side of the new relationship).

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 78 Super User 2025 Season 2

#2
Jerry-IN Profile Picture

Jerry-IN 75

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard