cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Community Champion
Community Champion

Re: Edit Form, Excel or Sharepoint

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
Highlighted
Community Champion
Community Champion

Re: Edit Form, Excel or Sharepoint

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.

Highlighted
Helper I
Helper I

Re: Edit Form, Excel or Sharepoint

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

Highlighted
Community Champion
Community Champion

Re: Edit Form, Excel or Sharepoint

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.

Highlighted
Helper I
Helper I

Re: Edit Form, Excel or Sharepoint

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

Highlighted
Helper I
Helper I

Re: Edit Form, Excel or Sharepoint

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

PFA

 

Thanks

Highlighted
Community Champion
Community Champion

Re: Edit Form, Excel or Sharepoint

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.

 

Highlighted
Community Champion
Community Champion

Re: Edit Form, Excel or Sharepoint

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

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,008)