Unanswered

Exporting to Excel - not CSV - multiple sheets

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'd like to export information from a Powerapps app to an Excel file. I need to export information on customers and contacts and so would like to create an Excel file on the users desktop that contains the customer info on one sheet and contacts on a second. This information will be stored in two collections. I do not believe I should ever exceed 2000 rows of either data.

I've watched a few videos on exporting, but most write to CSV files. I think (could be wrong) that I would need an xlsx file because of the two sheets. I saw one video writing to Excel but it wasn't called from within Powerapps - just Power Automate - would I set it up similarly as creating a CSV? How do I create the second sheet? The video I saw said you had to create a blank template file, do I need to do that? I write to a CSV file somewhere else so was wondering if I can somewhat copy that automate but make changes?

If there is a video that shows how to do this, I'd appreciate the help.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Firstly you cannot export to Excel (or CSV for that matter directly from Power Apps - this video sets out the process exporting to Excel using Power Automate, However you cannot write the file back to the user's desktop - the best you could do would be email it to them or store it in their OneDrive.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. I have watched that, but I wasn't sure how to create two sheets, unless somehow I can make two tables in the same sheet - I'd rather not make two files.

And I misspoke...I have been able to make a CSV on the desktop on Onedrive. Wasn't sure if I can simply follow similar steps for a xlsx file but within Powerapps using Automate. This video exported data right from Sharepoint, but I'd have to do lookups to get values from other lists so figured I can do all that in collections and then export them. So I wasn't sure how much I can follow the video.
Thank you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I've watched the referenced video for an Excel file, but it is different in that I ant to pass two collections to the flow and not get data right from Sharepoint. I pulled the collections over and can create CSV files, but I'd really like to use one Excel file with two sheets.

One issue is I need the columns in a specific order but when JSON is brought over, it puts them in alpha order. How do I put them in my order?

Another issue, the video references the SP column names, but how do I reference the columns coming in the JSON? It seems as though the data is being read properly, because if I create a CSV it is right.

I could potentially get around this if I pull the data directly from SP, but I think I would run into problems trying to retrieve values that in PowerApps, I can do LookUps on...not sure I can do that in a Flow. For example, I link projects to customers by the ID of the customer. I can do a Lookup using the ID to get the name. In what I want to put into Excel, there's a lot of that type of retrieving needed - it was easy to 'assemble' into the collections.

Anyone have suggestions?