Power Platform Community Forum Thread Details

Hello,

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.

For example:

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?

Any help is much appreciated.

Thank you.

Categories:

Microsoft Dataverse with Power Apps