Solved: How to save data from form to excel

I am starting with powerapps actually , so please help me out with this noob question

I am just creating a basic from,which contains dropdown,date picker,text box etc., to get inputs from end users,but i don't get how to save the given data to the excel file (or other datasources) when the user clicks on submit button ?

I tried creating an app from this excel and i am able to add data and save but how to add any other controls like date picker/dropdown etc and link it to the excel please help ?

Categories:

Connecting to Data

General Questions

Hi @vish_p,

Could you please share a screenshot about your app's configuration?

Where does your Excel file store?

I assume that your Excel file is stored within your OneDrive, I have made a test on my side, please take a try with the following workaround:

Format the date column within your Excel table as Short Date type or Long Date type.

Generate an app from the Excel table (Excel file) stored within your OneDrive.

Then the Edit form would be generated as below:

The end users could fill in the Form, and then click the "Submit" button to save your form data into your Excel table.

In addition, I also agree with @dinusc's thought almost, because of Time zone, the date value you filled within the Edit form may be different from that within your Excel table.

More details about generating an app from Excel table, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-data

Best regards,

Kris