Export to CSV is missing columns

Like (0) Share

Report

Posted on 9 Jun 2022 14:14:49 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:

Tables

I have the same question (0)

All responses (4)

Answers (1)

ingovals 140 on 13 Jun 2022 at 11:01:01

Like (0)

Report

Re: Export to CSV is missing columns

@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
ingovals 140 on 13 Jun 2022 at 10:52:07

Like (0)

Report

Re: Export to CSV is missing columns

@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
Verified answer

EricRegnier 8,714 Most Valuable Professional on 11 Jun 2022 at 06:54:04

Like (2)

Report

Re: Export to CSV is missing columns

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
365-Assist 2,317 Moderator on 09 Jun 2022 at 23:32:17

Like (0)

Report

Re: Export to CSV is missing columns

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

Was this reply helpful? Yes No