cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Exporting SharePoint List as CSV (template)

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
Highlighted
Community Support
Community Support

Re: Exporting SharePoint List as CSV (template)

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

Highlighted
Anonymous
Not applicable

Re: Exporting SharePoint List as CSV (template)

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!

Highlighted
Helper I
Helper I

Re: Exporting SharePoint List as CSV (template)

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 ? 

Highlighted

Re: Exporting SharePoint List as CSV (template)

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!






Highlighted
Helper I
Helper I

Re: Exporting SharePoint List as CSV (template)

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

Highlighted
Helper I
Helper I

Re: Exporting SharePoint List as CSV (template)

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  ?

Highlighted
Anonymous
Not applicable

Re: Exporting SharePoint List as CSV (template)

Capture.PNG 

 

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

Highlighted
Post Prodigy
Post Prodigy

Re: Exporting SharePoint List as CSV (template)

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,732)