Unanswered

Add multiple columns from lookup table

(0) Share

Report

Posted on by peterharket

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (2)

Report
Hi @peterharket ,

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

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

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.

Was this reply helpful? Yes No
peterharket 28 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
peterharket 28 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No