Export Power Apps data to Excel using Power Automate flows 09-05-2023 01:27 AM

[RezaDorrani]

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​

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

watch?v=tQCBWMR7T64

[sami_mrs]

Also, I noticed that there is no clue to convert .csv to .xlsx through power automate. 

CSV columns are not having option to set column width while saving gallery data or any other data (SP List or table). 

[sami_mrs]

Hi, 

It is only possible to export to csv. But why it is not able to get Export to Excel directly? 

CSV output is not convenient format to users. If it is excel format, it will be very very useful.  

[ecocycle]

Amazing!!! Thank you!!