Exporting SharePoint List as CSV (template)

[Anonymous]

Hi, 

I originally wanted to export SharePoint list as Excel file to a SharePoint folder every week, but I couldn't find how to do this anywhere so I decided to use Microsoft's template and export it as a CSV instead. With that, it works fine other than the CSV file is extremely messy. There are many columns that I do NOT want to be included and the columns were renamed in a weird way. Some of the list items are gibberish as well, rather than the actual value. Screenshot provided.

Is there any way to edit this and make it look better and only include the columns I'd like?

Or better yet, anyone knows how to do this with an Excel file?

[v-yamao-msft · Accepted solution]

Hi @Anonymous,

Have you tried to enable Custom for the Columns? With Custom enabled, you are able to select header and value of the columns that you want.

Please take the following screenshot for a reference:

Best regards,

Mabel Mao

[Anonymous]

Hi @v-yamao-msft,

Thank you! I was playing around with that earlier but for some reason I switched the header and value around. This should do!

[Anonymous]

Hi Mabel,

I am using this flow as well, but i need to customize it alot beecause i have alot of data. 

Besides the columns, i would like for certain values. For example i have this column "Offices" and i would like to pull out the data only for Chicago.

Also would i able to program it to run daily report for each offices ? Here is my scenario. I have a huge database where a team adds data for various offices on daily basis.

I would really like to pull out CSV file for each office on a daily basis. I need to know how many items were added for each office a daily basis. 

Any suggestions please ? 

[Anonymous]

Hi @Anonymous,

You can do this in the get items action from SharePoint. First, make sure to select the show advanced options link at the bottom:

Then make sure to fill the odata filter in the correct way. In your case it could be:

Offices eq 'Chicago'

I hope this is helpful for you!

Cheers,

Daniel

[Anonymous]

Thanks for the fast reply Daniel. But it doesn't work, cause my Office colum is a calculated column

[Anonymous]

Hey guys,

This flow works great but i need only 1 adjustment. I run a report daily, and the flow grabs all the data from my sharepoint list, meaning old data as well.  Instead of the entire database i would like to have it per day. Like how many items were created today and so on. Any suggestions please  ?

[Anonymous]

 

Is there a way to get all value as it is in list??? @Anonymous @v-yamao-msft 

[akbarmahfuzalam]

Hi Mabel,

When I am creating CSV Table I am not able to see the Header option.

 Help is required  How do I enable the header