Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / where is define what f...
Customer experience | Sales, Customer Insights,...
Answered

where is define what field to show up instead of the recorded id in a view ?

(0) ShareShare
ReportReport
Posted on by fsim 25

Hi there ! 
I'm pretty sure my question is not 100% clear.

So let me take an example, 

If I look in our system, at the case/incident table, I'll find many fields like "owner", "product", "creator" and so on. For this example, lets focus on "product". Within the Case entity reccords, the saved value for product is ProductID. Still on my screen I see the Product name (?).

My question is : where is this rule saved ? where can I find what is the flied to show up instead of the actual saved value for the "Product" records ?

I need this for BI purpose.

Using PowerBi, I don't even get the ProductID, I get the full record with all the fields and I would like to know wich one I should chose.

Can someone help me on this ?

thanks a lot in advance

fred 

  • fsim Profile Picture
    fsim 25 on at
    RE: where is define what field to show up instead of the recorded id in a view ?

    Thanks a lot.

    I never thought to click on the entity name. I always unfolded it :)

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: where is define what field to show up instead of the recorded id in a view ?

    Hi fsim,

    Based on your description, product field that in case view is one lookup field, which show Product name in the view.

    The Lookup text always displays the Primary field of the related entity [i.e Name].

    pastedimage1629165011108v1.png

    However,  Lookup columns show its guid and not name that we see in Dynamics 365 lookup In Power BI. 

    You can use LOOKUPVALUE function to show data from other table easily. 

    LOOKUPValue(Target table result field, Target table key, Source table matching key as on Target table)

    Dynamics 365 Lookup fields in PowerBI | Lovita ? CRM (wordpress.com)

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Holly Huffman Profile Picture

Holly Huffman 103

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 51 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans