Simplified access to entities through foreign key relationships

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review Summary of what’s new. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Makers can now write formulas that work seamlessly between entities, following lookups for related information.

For example, a record in the Accounts entity might have a Primary Contact field that is a lookup to a record in the Contacts entity. Previously, the maker had to manually look up records across entities, which meant knowing about and working with a foreign key. Now, a maker can simply write:

First( Accounts ).PrimaryContact.FullName

The maker then has access to all the PrimaryContact fields, such as Fullname, EmailAddress, or any other field.