Unanswered

Lookup Column in Dataverse Table

(0) Share

Report

Posted on by oshinjain Microsoft Employee

Hello

I am creating a canvas app and have created a lookup column in my employee details table as company code. This column is related to table companycode mastertable which have columns company name as primary column, company code and country.

When I am in the employee details table and using the company code column it is reflecting values of Primary column which is

company name whereas I want to see the company code values. when working through app it is showing correct values but in table it is not.

Attached is the image where company name and company code is showing same value.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @oshinjain

Lookup columns always refer to the Primary Name column in your related table. You can add (in your view) the company code to the view if needed (choosing related and adding the column when building the view). You can also setup the Lookup view of your CompanyCode table to show the CompanyCode first and then the Primary Name field if you want as when you are populating the lookup it will display the CompanyCode first and then the Primary Name field. Note, once you select it will display the Primary Name field though in the Lookup column...

Was this reply helpful? Yes No
oshinjain Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Drew

So you mean I will not be able to see the actual company codes in the company code field in this view.

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

Like (0)

Report
Copy link

Link copied!

Hi @oshinjain

If you want to see the Company Code in the View of the Employees you can definitely do this. When adding fields to your view of Employees you can click on the "Related" and this should show your Company Code table since this is a related table from your lookup. From here you can add the Company Code to your view...

Was this reply helpful? Yes No