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

Community site session details

Session Id : sbtoR56K46subt8Nz2m7LS
Power Pages - General Discussions
Unanswered

Relating one contact to multiple accounts

Like (0) ShareShare
ReportReport
Posted on 20 Jan 2023 03:34:58 by 234

Hi, everyone, 

 

Can anyone help me with this use case? Recent consultations and feedback gave me the direction of single users/contacts relating to multiple accounts. I've tested and noticed that the Company Name column in the contacts table only receives one entry. The idea that I have is to simply create multiple Company Names (lookup column) that would satisfy the need. And, on the relationship side of things, it would create multiple one-to-many relationships. 


Is my approach correct? Thank you. 

 

@OliverRodrigues @Inogic 

Categories:
  • oliver.rodrigues Profile Picture
    9,342 Most Valuable Professional on 01 Feb 2023 at 08:12:24
    Re: Relating one contact to multiple accounts

    I haven't played around with Connections + Portals, not sure how Portals deals with connections.

    Quick question @apangeles, can the same contact be part of multiple accounts? Have a think if you want you need is a 1:N or N:N.

    There is an OOB 1:N relationship which you might be able to use, it's called Primary Contact, this is represented by a lookup in the Account table, and by a subgrid on the Contact table.

     

    Hope this helps

  • Inogic Profile Picture
    1,043 Super User 2025 Season 2 on 01 Feb 2023 at 07:22:27
    Re: Relating one contact to multiple accounts

    Hi @apangeles 

     

    Did our suggestions work for you? If yes please mark it as accepted solution or else let us know if you need any further assistance.

     

    Thanks!
    Inogic Professional Services
    An expert technical extension for your techno-functional business needs
    Power Platform/Dynamics 365 CRM
    Drop an email at crm@inogic.com 
    Service: http://www.inogic.com/services/ 
    Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/ 

  • apangeles Profile Picture
    234 on 30 Jan 2023 at 02:26:50
    Re: Relating one contact to multiple accounts

    Hi, Inogic, thank you for these resources. I'll test them out! 

  • Inogic Profile Picture
    1,043 Super User 2025 Season 2 on 20 Jan 2023 at 06:52:58
    Re: Relating one contact to multiple accounts

    Hi,

     

    I think you should use "Connections" for your scenario to link one contact with multiple accounts. You can refer this Microsoft document on Connections - https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/connection-entities?view=op-9-1

     

    Also you can see the verified solution by "Lu Hao" in this community forum post who have same scenario as yours https://community.dynamics.com/365/sales/f/dynamics-365-for-sales-forum/403664/connect-contact-to-multiple-accounts 

     

    Hope this helps.

     

    Thanks!
    Inogic Professional Services
    An expert technical extension for your techno-functional business needs
    Power Platform/Dynamics 365 CRM
    Drop an email at crm@inogic.com 
    Service: http://www.inogic.com/services/ 
    Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/ 

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35

Loading complete