Do you know how to submit data from Power Apps to Excel? No need to worry!
This Power Apps tutorial will teach great detail about submitting data from a Power Apps form to an Excel sheet.
How to Submit Data From Power Apps to Excel
Let’s take a simple scenario to workaround with this:
- Setup an Excel Sheet and format it as a table
- Upload the Excel file to any cloud database like OneDrive, OneDrive for Business, etc.
- Create Power Apps Canvas App and Connect the Excel
- Insert a Power Apps Edit form and connect the Excel to it
- Save, Publish, and Preview the app
1. Setup an Excel Sheet and format it as a table
- I have an Excel Sheet named “Customer Details“. Inside this, I have added some different columns and respective records.
|Column Name||Data Type|
|Country And Area Code||Text|
- After adding data to the Excel sheet, you should set up the Excel Sheet Format As a Table, and also check the My table has headers option, as in the screenshot below.
- Once the Excel Sheet is ready, you should provide the Table name [Customer_Details] under the Table Design below.
2. Upload the Excel file to any cloud database like OneDrive for Business
- Now, open OneDrive for Business -> Click on the + Add new button -> Select Files upload option -> Select respective Excel file [Customer Details] from your local device -> Click on the Open button.
- Once the Excel file is added, it will appear under the “All” files dropdown, as in the screenshot below.
3. Create Power Apps Canvas App and Connect the Excel
- Next, we need to connect this Excel sheet to the Power Apps app and submit data from Power Apps to the Excel sheet.
- For that, I have created a blank canvas app -> Select the + Add data -> Select a data source as OneDrive for Business -> Choose an Excel file [Customer Details.xlsx] as in the screenshot below.
- Next, Choose the Excel table [Customer_Details] -> Click on the Connect button.
- Once it is connected to the app, you will get a data source under the In your app drop-down, as shown below.
4. Insert a Power Apps Edit form and connect the Excel to it
- In the Power Apps app -> Select the default screen and rename it to “NewCustomerScreen” -> Insert an Edit form control as shown below.
- Select the Edit form and add the Data source as an Excel table [Customer_Details] like below.
- Then, select the Edit fields option to add the respective Excel fields per the needs.
- Once the Excel fields are added, change the Default mode property to “New” as in the screenshot below.
- Next, insert a Save icon and set its OnSelect property as:
OnSelect = SubmitForm(frm_NewCustomer); ResetForm(frm_NewCustomer)
- SubmitForm() = This Power Apps function helps us to save any changes in a form control to the data source
- frm_NewCustomer = Power Apps Edit Form Control
- ResetForm() = This Function is used to reset the contents of a form to their initial values before the user makes any changes
5. Save, Publish, and Preview the app
- Once your Power Apps app is ready, Save, Publish, and Preview the app. When a user enters a new record in the Power Apps edit form, it will be submitted in the Excel sheet.
- To get the new record in an Excel file, go to OneDrive and open the respective Excel file as in the screenshot below.
This is all about submitting data from the Power Apps app to an Excel Sheet.
I hope from this Microsoft Power Apps tutorial; you learned in detail how to submit data from Power Apps to Excel in detail.
Also, you may like some more Power Apps tutorials:
- Power Apps Modern Button Control
- Power Apps Button OnSelect
- Show or Hide Label Control On Button Click in Power Apps
- Display SharePoint Person Column in Power Apps Dropdown
- Power Apps Combo Box Control
- Delegation Warning in Power Apps Combo box [How to Overcome]
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.