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!

[KeithAtherton]

Hi @blinabj,

Is your Excel file stored online in OneDrive for Business, SharePoint Sites, or Office 365 Groups?

If so, you can connect to Excel directly rather than use a Power Automate flow:

---

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

[blinabj]

Hi @KeithAtherton,

My original data is stored in a SharePoint list, and then from that data I have made a collection in PowerApps that I want to export as Excel.

And I need the opportunity to create several Excel exports from different collections, so I can't just edit an original Excel file.

Thanks for taking the time to help!

[KeithAtherton]

Thanks for the follow-up info. Can the Power Automate Excel "Create table" operation help?:

---

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

[blinabj]

Thanks @KeithAtherton.

I have tried using that, but I need to create the file in a step first if I am going to use that, and I dont know how to do that in Excel format. Do you know of such step that works? I have found severalt, but none that I think works...

[KeithAtherton]

Thanks, I understand. There are several "Create file" options which may help:

Another option may be to have an existing Excel file which you then copy each time:

---

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

[Rusk]

Yes you can parse the JSON as follows:

[blinabj]

Thank you so much for helping me, @Rusk ! I have tried exactly what you are suggesting. And it ends up looking like this:

I don't know if that is because of how my input looks or why it ends up like that... because I have seen youtube examples doing exactly what you are suggesting and getting it into the right format...

I need it to look like this:

Really appreciate the help! 😀

[Rusk]

Hi again,

It must be something with the way your data is structured?  I just tested it and it works for me 😛

Result:

[blinabj]

Thanks for clearing that up, @Rusk ! That's what I thought it might be... The data is coming from a SharePoint list, and is used to create a collection in PowerApps that is then used to create the Excel-file. And it looks like this in PowerApps:

And when I use the Compose step in the flow, the output looks like this: 

Does your Compose output look the same?

Really appreciate the help😊