How to export data from PowerApps to Excel

[blinabj]

Hi,

I want to export data from a PowerApps collection into Excel (created in the flow and stored in SharePoint). I am able to do it into a CSV file that opens in Excel, but the columns merge to one. How can I make it go from this table:

To this tabel:

Ideally I would like to make these formatting changes in the flow if possible. I cant do the changes in Excel, because the Excel goes automatically to the user and I want it to look nice when they recive it.
Here is my flow:

The Input looks like this at the step called Input: [{"name":"Nora","color":"pink"},{"name":"Tom","color":"green"},{"name":"Jim","color":"blue"},{"name":"Tim","color":"black"},{"name":"Lola","color":"green"}]

Can I use Parse JSON or something similar in the flow to make this happen? And which steps do I then need to take?

Appreciate the help!

[Rusk]

Mine looked like this:

[blinabj]

Thanks @Rusk 😊

My ParseJSON output looks exactly the same, I don't understand this...

Any suggestions to other ways of doing it?

[Rusk]

Hi again,

Very strange!  I still feel like the way the data is structured is the problem. It seems like its not picking up the "Nam" column.  When you collect the data, how does it look in collectionName?  What are the column names when you view the collection?  I assume it should look like this but its just so strange... might be good to confirm

I did notice in your Inputs / Outputs it says "Nam" instead of "Name"... could that be relevant?

[blinabj]

Thanks for responding @Rusk ! The spelling of "Nam" shouldn't matter, just a small spelling mistake there😅

Here is my collection, it looks the same as yours:

Any other ides to what the issue might be? If not do you know another way to do it?

Really appreciate your help!

[Rusk]

Hi again,

What do you have for Create CSV table for the "Columns"?  I have mine set to "Automatic".  

[Rusk]

One last idea... do you have this experimental feature turned on?  I do not:

[blinabj · Accepted solution]

Hi again @Rusk,

I really appreciate you helping me!

I checked the "Automatic" on the CSV table creation and that the experimental feature is turned off, and both of them are equal to your screen shots.

But, I found a way to do it! It is not a really nice way, but I was able to do it like explained in this video: https://www.youtube.com/watch?v=Kupz71dWYyY

I use PowerApps at the starter and input of the flow, and I use SharePoint instead off OneDrive, and this works.

Thanks for all the help!