cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peterharket
Frequent Visitor

Add multiple columns from lookup table

Hi!

 

Is there a way to add other columns besides the "main" ID column from another table when using the lookup column function?

I know that in Sharepoint, you can lookup another table, and then select which columns in addition to the "main" ID column you would like to bring back to your original table.

 

Peter 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @peterharket ,

Sorry, you only get that main column.  There are some things you can do though...

  1. Define views that will show columns from the lookup table.  When you create your view you can choose "Related" and then select additional columns from the lookup table
  2. Similar to #1, you can define a Quick View form for your lookup table and then in your main form you can add a section and choose to add the Quick View form from your lookup entity.  This will display the fields selected from that table.
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

4 REPLIES 4
dpoggemann
Super User
Super User

Hi @peterharket ,

Sorry, you only get that main column.  There are some things you can do though...

  1. Define views that will show columns from the lookup table.  When you create your view you can choose "Related" and then select additional columns from the lookup table
  2. Similar to #1, you can define a Quick View form for your lookup table and then in your main form you can add a section and choose to add the Quick View form from your lookup entity.  This will display the fields selected from that table.
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

The view did it for me! Guess it doesn't really make sense to physically add the data from another table to the table in question, so a view that joins the relevant data only when needed makes good sense!

One thing though:

 

If I add a related column to a view (let's say product name), and then a user adds data (or rather selects a product name from the lookup), where will the data entered for the product name be stored?

dpoggemann
Super User
Super User

Hi @peterharket,

 

This is only a "view" into those fields and all the data is stored on the Product table, you are just pulling those fields into your view.

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Helpful resources

Announcements
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 (1,758)