Create a custom multi-table lookup with a virtual table. The easy way.

In dataverse, a custom multi-table (polymorphic) lookup allows you to create a relationship between multiple tables with a common field. This is similar to a regular multi-table lookup or joins but with the added flexibility of relating to multiple tables using the same field.

Users can create and modify custom multi-table lookups at this time via the SDK or Web APIs. Interactive user interface support will be coming in a future release. How it is done can be found on this learn page.

Microsoft has released a new feature within custom multi-table lookups where we can now include virtual tables, including the AAD user table. Let’s have a look at how we can do this.

How do we do this the easy way?