Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Lookup Column in Dataverse Table

(0) ShareShare
ReportReport
Posted on by

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:
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 on at
    Re: Lookup Column in Dataverse Table

    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...

    dpoggemann_0-1705539973236.png

     

  • oshinjain Profile Picture
    oshinjain on at
    Re: Lookup Column in Dataverse Table

    Hello Drew

     

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

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,278 on at
    Re: Lookup Column in Dataverse Table

    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...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics