cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vignesh_2112
Helper II
Helper II

Edit Form, Excel or Sharepoint

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

7 REPLIES 7
eka24
Super User
Super User

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.

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

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.

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

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

PFA

 

Thanks

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.

 

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.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,987)