Skip to main content

Notifications

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

How can I add data sources to an extended data entity without increasing its records.

(1) ShareShare
ReportReport
Posted on by 148
Hi,
 
I have the EcoResReleasedProductV2Entity which has 15 records in a DataAreaId which I'm currently working on. I need to add 2 fields to that entity (ProductName, CategoryName) so I extended the data entity and added these 2 data sources: EcoResProductCategoryAssignmentEntity and EcoResProductTranslation. But when I add these datasources, it appears it takes all the records from within those data sources and it increases and duplicates the records in the entity I extended. 
 
So when I check the entity again, I dont have just 15 records, I have like 200K and more. I just need to add those fields with their proper value and that it shows acoordingly with those 15 records. How can I do this? I think it might be with how those data sources relate to the entity but don't know exactly how to configure it or change it.
 
Thanks in advance.

Here are the data sources: 
  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    How can I add data sources to an extended data entity without increasing its records.
    Refer to the below blog for adding an virtual field through extension.
    Thanks,
    Girish S.
  • Daniel Mora Profile Picture
    Daniel Mora 148 on at
    How can I add data sources to an extended data entity without increasing its records.
     Thank you Girish and Andre for answering.
     
    Unfortunately, I tried both things and adding EcoResProductSystemLanguage table inside the DataSource of EcoResProductTranslation table didn't work, it also increased its records and also Product in the EcoResProductSystemLanguage is just a number, not the name and it doesn't have any field as Name. I even noticed that just the fact of adding the data source does this without me adding any field. So then, I tried adding a computed field as Andre suggested but it won't let me add a new method even though is an extension of the entity:

     
    On a side note, I don't know why the new updated forum won't let me reply directly to your responses.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    How can I add data sources to an extended data entity without increasing its records.
    Hi Daniel,
     
    It is al about setting the correct relations on the data sources. As mentioned by Girish, there can be multiple translations for a single product. One product can also have multiple category assignments. Instead of adding the data sources, you can also consider virtual fields: Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Learn
  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    How can I add data sources to an extended data entity without increasing its records.
    Hi Daniel,
     
    EcoResProductTranslation will have many records for same product in different languages. You can use EcoResProductSystemLanguage table will have product with current system language id. 
    So, try adding EcoResProductSystemLanguage table inside the DataSource of EcoResProductTranslation table and check.
     
    Thanks,
    Girish S.

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…

Vahid Ghafarpour – Community Spotlight

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

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans