A lookup column in Microsoft Dataverse is how you reference a record from another table—similar to a foreign key in traditional databases. It links two tables, allowing relationships and cross-references between their data. A lookup column stores the reference to another table’s primary key.
For example:
In your Order table:
• You might add a lookup column Customer that points to a record in the Customer table.
• When creating or editing an Order, you select which Customer it belongs to (via lookup).
Because that lookup gives you access to related fields, you can show Customer name, address, etc., directly or via logic.
In the screenshot, when creating a new column, selecting the Lookup data type requires specifying a Related Table. This tells Dataverse which table the lookup will point to
Key Takeaway
A lookup column acts as a relational bridge in Dataverse—functioning like a foreign key—ensuring tables can share and display meaningful related data.
