cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
orchidaceae
Level: Power Up

SharePoint - filled form doesn't update in SharePoint list

Hello all,  My colleague and I (n00bs) are trying to create an app where users can input data which is then sent to a SharePoint list. The form is visible within the app and when the app is 'played' you can fill the app in and it says that your info has been submitted successfully.  However, when you go back to the SharePoint list there is no data added.  I'm sure this is something to do with flows/rules but we haven't been able to work out how to fix it and would appreciate some assistance! Cheers

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SharePoint - filled form doesn't update in SharePoint list

If you are using a form control tied to the SharePoint list for viewing and updating the data then you can use the SubmitForm() function to save the data to the SharePoint list. If you aren't using a form then you would need to use the Patch() to save the data back to SharePoint.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: SharePoint - filled form doesn't update in SharePoint list

Are you using the SharePoint connector in your app? How are you saving the data? 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
orchidaceae
Level: Power Up

Re: SharePoint - filled form doesn't update in SharePoint list

Well this is the problem. I think it works from a design point of view, but not technical. 

 

At the moment it's pulling in a form from a SP list, which displays. If you fill it out and click 'send' it takes you through to the next screen which says 'your form has been submitted' (or whatever), but I don't know what rule/action combo to enlist when you click 'send' to ensure that the data actually moves from the app to the SP list. 

 

 

Super User
Super User

Re: SharePoint - filled form doesn't update in SharePoint list

If you are using a form control tied to the SharePoint list for viewing and updating the data then you can use the SubmitForm() function to save the data to the SharePoint list. If you aren't using a form then you would need to use the Patch() to save the data back to SharePoint.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Community Support Team
Community Support Team

Re: SharePoint - filled form doesn't update in SharePoint list

Hi @orchidaceae ,

Could you please share a bit more about your scenario?

How do you save your form data into your SP list? Using SubmitForm() function or Patch function?

 

If you use SubmitForm() function to submit your form data, please take a try with the following workaround:

Set the OnSelect property of the "Send" button to following formula:

SubmitForm(EditForm1);        /* <-- EditForm1 represents the Edit form control in your app */
If( /* <-- Check if there is something error occurs when you submit new record, if error occurs, not navigate to next screen */
IsEmpty(Errors('YourSPList', EditForm1.LastSubmit)), /* <-- 'YourSPList' represents your SP list data source */
Navigate(NextScreen, ScreenTransition.None),
Notify("There is something with your SubmitForm function", NotificationType.Error)
)

 

In addition, you could also consider take a try to use Patch function to achieve your needs. Please set the OnSelect property of the "Send" button to following formula:

;
If( /* <-- Check if there is something error occurs when you submit new record, if error occurs, not navigate to next screen */
IsEmpty(
Errors(
'YourSPList', /* <-- 'YourSPList' represents your SP list data source */
Patch( 'YourSPList', Defaults('YourSPList'), EditForm1.Updates)
)
),
Navigate(NextScreen, ScreenTransition.None),
Notify("There is something with your Patch function", NotificationType.Error)
)

More details about Patch function, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

 

If the issue still exists, please consider take a try to re-generate a new app based on your SP list data source, then try your app again, check if the issue is solved.

More details about generating an app based on SP list data source, please check the following article or video:

Gnerate an app from SP list

https://www.youtube.com/watch?v=qwUt7MagAt4

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,796)