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.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,226)