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
This solution has been great. Thank you so much and appreciated your help!
Thank you so much. I will execute the solution you provide. I really appreciate your help
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
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