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 / Dataverse self-lookup ...
Power Pages
Unanswered

Dataverse self-lookup column

(0) ShareShare
ReportReport
Posted on by 252

Hi everyone, 

 

Just for curiosity, in what situations do I need to make a column with a lookup column type that connects to the same table? 

 

Thank you. 

Categories:
I have the same question (0)
  • Verified answer
    Fubar Profile Picture
    8,338 Super User 2025 Season 2 on at

    Could be many situations depending on your needs.  The classic example in data modelling is what is called a Bill of Materials (basically a Product that is made up of other Products each of which could be made up of other products etc etc), in Dynamics 365 there is one for Accounts with Child Accounts e..g. a Head Office account and it has Regional Offices.

    Similarly an Organiszation hierarchy, Management/Position hierarchy, would be other examples

  • apangeles Profile Picture
    252 on at

    Hi @Fubar 

     

    Thank you. In relation to this, I think, what if a contact has multiple accounts related to it? Can it be possible? 

     

    Because you've mentioned the bill of materials case, I assume a single product/material can be associated with multiple products, can a single contact be associated with multiple accounts? 

     

    Thank you. 

  • Fubar Profile Picture
    8,338 Super User 2025 Season 2 on at

    Yes, a Contact can be associated with many Accounts - however, out-of-the-box this relationship is not present (you would have to create it, a one-to-many between Contact to Account or a many-to-many between them) 

  • apangeles Profile Picture
    252 on at

    Hi @Fubar

     

    Thank you for your answers! I very much appreciate your time.

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
Jerry-IN Profile Picture

Jerry-IN 71

#2
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard