Answered

Export to CSV is missing columns

(0) Share

Report

Posted on by ingovals

140

I need to one time export some data to CSV for external use (creation of test data for import). I need the GUID of the table, and a whole number column.
For some reason Whole Number columns seem to be missing from CSV exports.

Any way to fix that?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you please provide screen shots of how you are doing the Export.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @ingovals,

Try to export the data from Advanced Find: in the Maker portal (https://make.powerapps.com) go to --> click on gear icon on the top right --> Advanced Settings --> Advanced Find (the little funnel on the top right) --> select your table in the "Look For" and the desired filters --> click "Edit Columns" in the ribbon and make ure the Whole Number columns is there -->< click the "Results" button in the ribbon --> and then Export

Hope this helps!

Was this reply helpful? Yes No
ingovals 140 on at

Like (0)

Report
Copy link

Link copied!

@EricRegnier This is at least closer to what I need, why are they hiding these options away. It seems newer versions have less features.
Only problem I have is that I can't add the ID column ( as in the GUID ) of the table here.

Was this reply helpful? Yes No
ingovals 140 on at

Like (0)

Report
Copy link

Link copied!

@365-Assist

I swear I had already replied to you with screenshots, but something must have gone AWOL.

Here are the images

Was this reply helpful? Yes No