cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex_Reig
Helper III
Helper III

Export sharepoint list in CSV with columns

Hi all,

 

I have created a flow to export data from sharepoint to Excel. The problem is that the file created has all data in one column and …

 

Alex_Reig_0-1636987413026.png

 

… I need to have the same columns as the sharepoint list.

 

Alex_Reig_1-1636987413029.png

 

 

The flow that I have created is the following:

 

Alex_Reig_2-1636987413041.png

 

Thaks in advance 🙂

 

Àlex

 

1 ACCEPTED SOLUTION

Accepted Solutions

The output of the Create CSV table appears to be OK. I think the problem may be how you are opening the file in Excel?

 

(1) Make sure that the filename has the extension .CSV or Excel may not be able to recognise the correct file format type. Your file seems to be opened in Excel as a text file. For example, my demo CSV file was opened as a plain text file in Excel - the results are similar to what you are seeing:

2021-11-15_17-00-45.png

(2) Try opening the file again in Excel but select *.* for All Files:

2021-11-15_17-11-46.png

For example, I renamed my test file to: RowsCSVfile (1).csv.txt

 

When opening the file I tell Excel that the file is delimited:

2021-11-15_17-02-10.png

The delimiter is a comma:

2021-11-15_17-03-44.png

Now the file opens successfully:

2021-11-15_17-19-17.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

6 REPLIES 6
ekarim2020
Super User
Super User

There is a Create CSV table option that you can use in the flow:

2021-11-15_15-11-07.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Alex_Reig
Helper III
Helper III

Hi @ekarim2020 

 

Sorry, there was an extra photo that i didn't attach before,

 

Alex_Reig_0-1636989384216.png

In my flow I have the create CSV table but it did'nt create more than 1 column,

 

(1) Please make sure that the filename ends in .csv

2021-11-15_15-21-07.png

 

(2) Check the Output of the Selection action. Did the SharePoint Get Items action return any results? For example:

2021-11-15_15-25-08.png

 

(3) Check the output of the Create CSV Table action. For example:

2021-11-15_15-26-22.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Hi @ekarim2020 

 

I attach a picture of what it shows 🙂

 

Alex_Reig_0-1636990760620.png

 

And that's the csv that I get:

 

Alex_Reig_1-1636990827544.png

 

The output of the Create CSV table appears to be OK. I think the problem may be how you are opening the file in Excel?

 

(1) Make sure that the filename has the extension .CSV or Excel may not be able to recognise the correct file format type. Your file seems to be opened in Excel as a text file. For example, my demo CSV file was opened as a plain text file in Excel - the results are similar to what you are seeing:

2021-11-15_17-00-45.png

(2) Try opening the file again in Excel but select *.* for All Files:

2021-11-15_17-11-46.png

For example, I renamed my test file to: RowsCSVfile (1).csv.txt

 

When opening the file I tell Excel that the file is delimited:

2021-11-15_17-02-10.png

The delimiter is a comma:

2021-11-15_17-03-44.png

Now the file opens successfully:

2021-11-15_17-19-17.png

 


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Alex_Reig
Helper III
Helper III

Hi @ekarim2020 

 

I did it with create HTML table instead of CSV and now it works,

 

Thank you for your help 🙂

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,373)