Unanswered

When viewing the columns for a table (E.G - Dataverse>Tables>Account>Columns) how do I export that list to a CSV?

(0) Share

Report

Posted on by LB123

Use Case -

We have hundreds of undocumented variables added to columns for almost all the entity types in our instance of D365. I need to get -

- field Display Name

- Logical Name
- Mandatory (yes/no)

- etc.

for these fields out of the dataverse into a csv file so I can assist the dev team in mapping what we need regarding APIs our D365 instance to get/put/delete data in these fields. I can view these by navigating to them in powerapps (Dataverse>Tables>Account>Columns) but there is no "export to CSV" option for this particular view. I can export raw data in these fields to a CSV if i step back a few screens but not the field properties.

with 183 rows in the "Lead" column copying this out manually will be quite tedious. looking for ways to get this info out of the dataverse fast.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Fubar 8,361 Super User 2025 Season 2 on at

Like (1)

Report

Use XrmToolBox (community based free to use download from https://www.xrmtoolbox.com ) it has a Metadata Document Generator tool that you can use to export a Data Dictionary to Word or Excel.

Edit: for row data either create a Model Driven App and export to Excel, or use FetchXML Builder in XrmToolBox

Was this reply helpful? Yes No
LB123 on at

Like (0)

Report

several questions -
1. how safe is XRM Toolbox to install and use? there is the ever present risk of leaking prod data which makes me very uncertain about hooking this up to a UAT/Dev database that might have some prod data in it (old organization, we sometimes come across prod stuff where it should not be) and there are use cases when I need to look at prod as well.

2. I have added it to the trial version of D365 on my personal machine well away from anything work related to have a look - once its connected to an instance of D365, how do you actually "open" a tool? this sounds very silly but 30 minutes of clicking the metadata document tool in every way that windows allows does not do anything. its definitely installed and hooked up to an instance of dynamics, I feel like I am missing a critical and very obvious thing and the few videos I have found they click a tool and it opens.

Was this reply helpful? Yes No