
Announcements
Hi.
Appologies if this has been answered before, it's seems like it should be strait forward.
Is it possible to create a lookup column that references another column in the same table.
I manage an aquarium, I have multiple water systems and some of them are connected together as in system 1 supplies water to system 2.
I have a table that lists all the systems and want a column, in that table that shows which other system supplies it.
Is that possible?
Hi @Paultys ,
Dataverse allows user to create self-referential lookup field.
Besides, we can define hierarchical data for the relationship.
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-query-hierarchical-data
Best Regards,
Wearsky