Notifications
Announcements
I've two Contact tables related to Employees (Parent) and their Clients (Child).
I'm looking to Export the "Employees" table Data in Excel where I can add a column from "Clients" table's "Name" field"/
Is it possible to get Excel Export this way?
@AnuragT
You can do it the other way around so you can adjust a view on the child record where you can add a column from the Employee.
I expect that client has a lookup to the employee is that correct?
as per Mira with regards to Views. However, if you just need the data out you can create a Report via the Report Wizard (to access this functionality you will have to add the out of the box Reports table to a model driven app) this will allow you to create and run a Report and the Report has an Export to Excel option (as well as multiple other formats) https://learn.microsoft.com/en-us/power-apps/user/create-report-with-wizard
Can also get the data by using FetchXML Builder in XrmToolBox
@Mira_Ghaly thank you for the solution. I used this solution on table with approx 20 Column.
@Fubar your solution was used for other table where I needed approx 250 fields. Thank you!
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 793 Most Valuable Professional
Michael E. Gernaey 333 Super User 2025 Season 2
Power Platform 1919 268
