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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,428)