cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Exporting SharePoint List as CSV (template)

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?

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

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:

1.PNG

 

 

Best regards,

Mabel Mao

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

View solution in original post

8 REPLIES 8
v-yamao-msft
Community Support
Community Support

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:

1.PNG

 

 

Best regards,

Mabel Mao

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

View solution in original post

Anonymous
Not applicable

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!

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 ? 

Hi @Babalaul,

 

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

 

getitemsadvanced.png

 

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

 

Offices eq 'Chicago'

getitemsfilterodata.png

 

I hope this is helpful for you!

 

Cheers,

Daniel







Did I answer your question? Mark my post as a solution!


Proud to be a Flownaut!






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

Babalaul
Helper I
Helper I

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
Not applicable

Capture.PNG 

 

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

Hi Mabel,

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

 

 Help is required  How do IHeader.JPG enable the header

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,818)