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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,372)