cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Carl__D
Helper I
Helper I

Dataverse Lookup - Pre-populating additional fields like in SharePoint

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. 

Carl__D_0-1628260104469.png

 

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.    

1 ACCEPTED SOLUTION

Accepted Solutions
MayankP
Responsive Resident
Responsive Resident

Hi @Carl__D,

 

Data verse will soon have multi table looks fields …

 

refer following article below...

https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/data-platform/multi-table-loo...

 

https://www.youtube.com/watch?v=UuK92K0CLQE..

 

if this resolves issue you can implement it and it will available in Sep 2021....

 

View solution in original post

1 REPLY 1
MayankP
Responsive Resident
Responsive Resident

Hi @Carl__D,

 

Data verse will soon have multi table looks fields …

 

refer following article below...

https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave1/data-platform/multi-table-loo...

 

https://www.youtube.com/watch?v=UuK92K0CLQE..

 

if this resolves issue you can implement it and it will available in Sep 2021....

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,250)