Header row is missing from a CSV table export from a SharePoint site.

Like (0) Share

Report

Posted on 7 Jan 2020 21:57:38 by Sirius Microsoft Employee

Hello All,

The 'Include Headers' is no longer available in 'Create CSV table', and the header is missing from the CSV output file. What do I need to do to include the header in the CSV?

Annotation 2020-01-07 135531.jpg Annotation 2020-01-07 135622.jpg

All responses (4)

Answers (1)

Verified answer

v-litu-msft on 14 Jan 2020 at 08:43:28

Like (0)

Report

Re: Header row is missing from a CSV table export from a SharePoint site.

Hi @Sirius,

Yes, the header should enter manually.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sirius Microsoft Employee on 13 Jan 2020 at 10:03:16

Like (0)

Report

Re: Header row is missing from a CSV table export from a SharePoint site.

I added a 'Select' workload before the 'Create CSV Table' and work. but I have to enter the Title/Header manually
Sirius Microsoft Employee on 10 Jan 2020 at 20:03:40

Like (0)

Report

Re: Header row is missing from a CSV table export from a SharePoint site.

I am able to create the csv file with Title header by adding 'Select' before the create csv table.
v-litu-msft on 08 Jan 2020 at 01:34:18

Like (0)

Report

Re: Header row is missing from a CSV table export from a SharePoint site.

Hi @Sirius,

If you are using the Create CSV table action to create a CSV table, there should be Header names in the Header fields, not dynamic content, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.