Edit Form, Excel or Sharepoint

[Vignesh_2112]

I have to create a form that enables user to key in data and once they submit the form, it should be saved to a excel or Sharepoint list for future reference. 

Issue:

I created an Excel file with Table headings and then used this as destination file for the PowerApps to save data.

When I run the App, the form becomes blank and don't know whats the error. I too tried with SharePoint as Source file too.

Is there a way apart from this?

[eka24]

Insert two buttons to switch the display modes:

Button2 Onselect: NewForm(YourFormName)

Button1 Onselect: EditForm(YourFormName)

You can also insert a Gallery1 alongside the Form and  put:
Gallery1.Selected in the ITEM of the form

I believe clicking the buttons will resolve it.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Vignesh_2112]

I'm intended to collect some data from the App like date, name and timer function, etc.

This things need to be saved  in a excel or SharePoint file for reference.

PFA

Title, Date and Timer will be collected automatically from the App and on clicking a button I need to save the data to excel or SharePoint

Thanks

[eka24]

I take this as a follow up question, as you were dealing with a blank form?

To send the data to the excel or sharepoint, Once you are using a form, put:

   SubmitForm(YourFormNameHere) on the OnSelect of the button

After clicking the button, that should be done.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Vignesh_2112]

Thanks for your reply, Once I click submit form, the excel or Sharepoint is not updated.

Am I need to use collect or patch function for this

[Vignesh_2112]

FYI. The form becomes blank when i go for play mode

PFA

Thanks

[eka24]

Where are the 2 buttons i suggested you insert? cant see them on your screen you have shown.

That will solve your issue.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24 · Accepted solution]

That is strange. May be it not a form.

For Patch:

Patch( Datasource, Defaults( Datasource), { Title:TextBox1.Text,  Timer:TextBox2.Text,Date:DatePicker22.SelectedDate} )

Change DatePicker22 to your actual name of the DatePicker

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.