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

Converting powerapps collection to excel spreadsheet

Hello,

 

I am trying to allow users of an app I am building to export their data to an excel spreadsheet. This seems like it should be a pretty straightforward thing to do, given that PowerApps Collections are basically just data sets, but I am hitting a brick wall in terms of the combined functionality of PowerApps and Flows.

 

All I need to be able to do is take the data from my collection, export it to an Excel XLSX file and then email it to them. 

 

The pieces seem to all be there, but they're just unable to speak to each other. Has anyone accomplished this or something similar?

1 ACCEPTED SOLUTION

Accepted Solutions

For anyone who runs into the same issue as me trying to export a collection from PowerApps to an Excel file, this is how I did it. Once I parsed the JSON, I created a CSV table. I then created a .csv file with that table in a OneDrive folder that's shared with my internal users. The issue I ran into after that was that there's no native support for converting a .csv file into an excel .xlsx file (why is beyond me). However, you can sign up for a free account on Cloudmersive https://cloudmersive.com/, and there's a function to convert a csv to xlsx. This worked perfectly for me, and I can now let my internal users export the data that they build in my app. Below is a screenshot of my final flow.

 

2019-11-14 15_04_49-Edit your flow _ Power Automate.png

 

 

View solution in original post

2 REPLIES 2
Helper II
Helper II

I am so close to figuring this out. 

 

2019-11-14 13_34_02-Run History _ Power Automate.png

 

In the screenshot above, I am taking the collection in JSON format from PowerApps, parsing it in Flows, then doing an Apply_to_each to update rows in an excel table. I can do 90% of that, but I hit an error when trying to map the JSON fields to the Excel table. The expression I am using is item()?['Headline']

 

Has anyone had success with doing something similar to this?

For anyone who runs into the same issue as me trying to export a collection from PowerApps to an Excel file, this is how I did it. Once I parsed the JSON, I created a CSV table. I then created a .csv file with that table in a OneDrive folder that's shared with my internal users. The issue I ran into after that was that there's no native support for converting a .csv file into an excel .xlsx file (why is beyond me). However, you can sign up for a free account on Cloudmersive https://cloudmersive.com/, and there's a function to convert a csv to xlsx. This worked perfectly for me, and I can now let my internal users export the data that they build in my app. Below is a screenshot of my final flow.

 

2019-11-14 15_04_49-Edit your flow _ Power Automate.png

 

 

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,011)