Dataverse Lookup - Pre-populating additional fields like in SharePoint
In SharePoint Online, you can create two lists and make one the LookUp for the other.
Using 'Add a column to show each of these additional fields' you can also auto-populate all the metadata with it.
List 1 = "New Employees" - You can add a new starter's name, start date, department, etc. When selecting Department it looks to list 2.
List 2 = "Department" (Lookup) - This has a 'Department' field with the list of Departments but also, lets say, includes a 'Software' field that shows the specific Software that should be given to staff in a certain department.
In SharePoint when referencing the Department list as a lookup from the New Employees list, I can choose a Department and also pull in the associated Software column, and any others.
I can't find a way to do this in Dataverse! What am I missing?