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?
Solved! Go to 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.
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
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.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
272 | |
257 | |
87 | |
39 | |
34 |
User | Count |
---|---|
339 | |
249 | |
130 | |
68 | |
48 |