Export Power Apps data to Excel in CSV format

In this video, you will learn how to export Power Apps data to Excel thanks to the JSON function which allows us to send Collections, Tables and Gallery data to Power Automate flow. The flow will build the CSV file and send a response back to PowerApps with the exported excel spreadsheet file link. The excel file will be available to download in Power Apps. Best part is the flow is reusable and can be connected to any Power App and can export tabular data.

#PowerApps​ #Excel​ #PowerAutomate​


Table of Contents:
00:00​ - Intro
01:05​ - Create a Power Apps export to excel button
01:45 - Create a flow to export excel data from Power Apps
04:09 - Call flow from Power Apps and pass JSON data
07:05 - Create CSV Table in flow from Power Apps JSON data
09:39 - Create excel file in OneDrive and get share link to file
13:07 - Respond to PowerApps from flow
17:11 - Test Power Apps button export collection to csv
18:01 - Reuse export button with gallery data
23:36 - Reuse export to excel flow with a different Power App
25:48 - Subscribe