In one of my early apps, the method for submitting and editing data via the app were performed via SubmitForm(frmNewEntry) and EditForm(frmEditForm) formula of OnSelect. (Patch was not applied).
Now that the app is 'Live' and being utilized, users have requested to include an additional column from the SharePoint Datasource. I have added the field from the datasource and saved my changes. However, when a user enters data into the new field, on a new form via the app or the customized form, the data is not being saved back to the datasource. Interestingly, when I add a new record via the SharePoint customize form, the initial refreshed view of the SharePoint list, shows the data that was added in the new field. However, after a second or a refresh, that data 'disappears'.
Any thoughts why it it isn't picking up the new field?
I'm having a similar problem with Patch. Looks like @TerrificTerri is having a similar problem today too.
Here is a screenshot of the app NOT seeing the "lat_long" column which is clearly in the list. There are a couple of others its not "seeing" either.
When I delete the columns from the Patch statement, it patches just fine.
Could you please share a bit more about your app's configuration?
I have made a test on my side and don't have the issue that you mentioned.
Please take a try to refresh the SP list data source manually within your app, then try your app again to check if the issue is solved.
In addition, you could also take a try to remove the SP list data source from your app and re-add it, then try your app again to check if the issue still exists.
If the issue still exists, you could consider take a try to re-create your app and add the SP list as as data source into it, then check if the issue is solved.
You could also take a try to use Patch function to submit data into your SP list. The formula as beow:
More details about the Patch function in PowerApps, please check the following article:
I have followed your instructions:
How else can we further debug this?
Confirmed a work around thanks to @tianaranjo:
@PowerApps Team, please consider this an issue with PowerApps - Sharepoint integration. The above is a workaround, not a fix. The original column name cannot be used even if its deleted.
I wanted to raise this issue again as I don't think the workaround is a viable solution. I now have the same issue with another app (described in initial post approx. 3 weeks ago). I connected to a SP list as my datasource and was submitting both New and Edited data utilizing the Patch function.
Today I added a column from the SP list and modified the Patch function to account for the new field. The Patch function errors (underlining full statement in red). So, I experimented and changed the OnSelect function of the 'New' screen to SubmitForm(frmNew) and it works fine.
Same is true for the 'Edit' screen - when OnSelect changed to SubmitForm,it works fine.
With that in mind, SubmitForm will work but I would like to know why Patch isn't working when a new column is brought in from the datasource -- any thoughts?
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021