How to Submit Data From Power Apps to Excel?

Have you faced any issues while submitting data from Power Apps to Excel?

If so, don’t worry- we’re here to help! This Power Apps tutorial will guide you on “How to submit data from Power Apps to Excel.”

How to Submit Data From Power Apps to Excel

Here are the steps to submit data from Power Apps to Excel:

  1. Format an Excel sheet as a table.
  2. Power Apps connect a data source to OneDrive for Business.
  3. Insert a Power Apps Edit form and connect the Excel to it.
  4. Submit Data From Power Apps to Excel.

Step 1: Format an Excel sheet as a table

I have an Excel file regarding “Customer Details” that has fields like:

Column NameData type
Customer IDText
Customer NameText
GenderChoice
Country And Area CodeText
Mobile NumberNumber
Emergency NumberNumber
EmailText
Submit Data from Power Apps app to Excel Sheet
  • Set up the Excel Sheet as Format As a Table.
Submit Data from Power Apps Canvas app to Excel
  • Once the Excel Sheet is ready, you should provide the Table name [Customer_Details] under the Table Design below.
How to Submit Data from Power Apps Canvas app to Excel Sheet

Step 2: Power Apps Connect a data source to OneDrive for Business

Now, we will create a blank canvas app and connect the data source to OneDrive for Business in Power Apps :

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create a Power Apps 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.
Submit Data From Power Apps to Excel
  • 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.
Submit Data From Power Apps app to Excel

Step 3: Insert a Power Apps Edit form and connect the Excel to it

  • On the Power Apps screen, insert an Edit form -> Set its Data Source property to:
Customer_Details

Where,

  1. Customer_Details = Excel table name
How to Add Data from Power Apps app to Excel
  • Then, select the Edit fields option to add the respective Excel fields per the needs.
How to Add Data from Power Apps app to Excel Sheet
  • The Power Apps form looks like the screenshot below:
How to submit data from Power Apps to a Excel file

Step 4: Submit Data From Power Apps to Excel

  • On the Power Apps screen, Insert a Save icon -> Set its OnSelect property to:
SubmitForm(frm_NewCustomer);
ResetForm(frm_NewCustomer)

Where,

  1. SubmitForm() = This Power Apps function helps us to save any changes in a form control to the data source
  2. frm_NewCustomer = Power Apps Edit Form Control
  3. ResetForm() = This Function is used to reset the contents of a form to their initial values before the user makes any changes
How to Submit Data From Power Apps to Excel Sheet
  • 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 and clicks on a save icon, that data will be submitted in the Excel sheet.
Submit Data From Power Apps app to Excel Sheet

This is all about submitting data from the Power Apps app to an Excel Sheet.

Conclusion

I trust this Power Apps tutorial helped you find a solution by explaining How to submit data from Power Apps to Excel.

Connecting an Excel table to an Edit form and using the “SubmitForm” function can easily help to submit data from Power Apps to Excel.

Also, you may like some more Power Apps tutorials: