Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Replacement field in data entities for Excel add-in

(0) ShareShare
ReportReport
Posted on by 1,169

Hi,

Greetings and thank you for reading this post!

I am creating a data entity for a table that let's say stores the recid for items, and I have created a data entity on that table alone.

This data entity would be used in excels using the add-ins.

But on the excel, instead of the recids of the items I want the ItemId to be shown.

Could someone please help me with a reference document?

With regards,

Abhinay

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at
    RE: Replacement field in data entities for Excel add-in

    Hi Abhinay,

    There are two options. You can add a datasource referring to the referenced table and add the ItemId field or you can add a virtual field.

    See the documentation for more information about these two options:

    Build and consume data entities - Finance & Operations | Dynamics 365 | Microsoft Learn (step 9 starts explaining related tables)

    Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Learn

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

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…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans