Answered

Exporting SharePoint List as CSV (template)

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

v-yamao-msft on at

Like (2)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

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

Was this reply helpful? Yes No