Answered

Power Apps - From Power Apps data export to excel

(0) Share

Report

Posted on by MichaelJordan12

Good day! Thank you for welcoming me to Power apps community. I would like to seek for help on how to export data from Power apps to Excel. Thank you so much

Categories:

Using Apps Using Formulas

Connectors

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

MVP-Phipps 3,494 Super User 2024 Season 1 on at

Like (1)

Report

Re: Power Apps - From Power Apps data export to excel

I would trigger a Power Automate Flow from your PowerApps to then retrieve the data and export it to excel you can handle this in Power Automate.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report

Re: Power Apps - From Power Apps data export to excel

Hi @MichaelJordan12,

This topic is too broad to give a solution.

Here is some steps for your reference:

1). Make sure that you have an excel table as your data source, which is important for Power Apps to create connection with the Excel

2). Create an excel sheet and format it as a table

3). Create an app directly based on Data Source(OneDrive or ExcelOnline), here I would suggest OneDrive. Actually, if it is not necessary for you to select excel as data source, I would suggest SharePoint list as your data source.

4). Power Apps will generate an app automatically based on your excel connection

5). There are 3 screens, BrowseScreen including a Gallery to display all the items, DisplayScreen including display form to display the selected record from the Gallery, EditScreen including an Edit Form to create/edit the record.

More details, you could check our official doc for reference:

Connect to Excel from Power Apps - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
MichaelJordan12 16 on at

Like (0)

Report

Re: Power Apps - From Power Apps data export to excel

Thank you so much. I will execute the solution you provide. I really appreciate your help

Was this reply helpful? Yes No
MichaelJordan12 16 on at

Like (0)

Report

Re: Power Apps - From Power Apps data export to excel

This solution has been great. Thank you so much and appreciated your help!

Was this reply helpful? Yes No