web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Associated View with 2nd level child entity error when export to excel

(0) ShareShare
ReportReport
Posted on by 1,235

Hi All,

I have a custom entity named key contact which link to Account entity. The associated view required to display the Country's Region. The country is a custom entity which also a lookup field in Account entity to Country entity.

I'm using Xrmtoolbox to link the Key Contact entity to Account then from Account to Country entity. The view is running fine on the form itself, record able to display correctly. However, when users try to export the data from the view to excel, the following error occurs. I tried change the alias name, but no luck.

Screenshot-2020_2D00_10_2D00_06-133054.jpg

Below is the fetchXML from xrmtoolbox

  
    
    
    
    
    
    
    
    
      
      
    
    
      
      
        
      
    
    
      
    
  

Any help is much appreciated.

Thanks.

Regards,
Teh

I have the same question (0)
  • gopi.royal999@gmail.com Profile Picture
    430 on at

    Try removing line no 15 -- <attribute name="ads_country" />

    And add the country name from ads_country entity below ads_regionafi.

  • Venedict Profile Picture
    1,235 on at

    Hi Reddy,

    Thanks for your prompt reply. I had tested, result still same error. The error is prompt seem it cant find the 2nd level child entity.

    Regards,

    Teh

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 80

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans