Unanswered

NewForm not creating new record in List

(0) Share

Report

Posted on by tianaranjo

497

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
I'm having a similar problem with Patch. Looks like @TerrificTerri is having a similar problem today too.

My issue:
Created a list ~2 months ago
Been iterating my app while connected to the list as a Data Source; adding removing columns, etc.
Today I went to try Patch and PowerApps is NOT seeing some of the columns in my List.

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.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tianaranjo,

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:

Patch(datasource,Defaults(datasource),{Title:"",Column1:"",Column2:"",...ColumnN:""})

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

Patch function

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hello @v-xida-msft and @tianaranjo,

I have followed your instructions:
Checked to see if data source is "Connected"
Yes it is
Refreshed Data Source
No change
Removed and re-added Data Source
No change
Recreate an app that is in production use:
Not an option
Use Patch function
I am using Patch function already. That is what is failing.
How else can we further debug this?

Thank you

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Confirmed a work around thanks to @tianaranjo:

add a new column to the Sharepoint list with a unique name
Example: "lat_long1"
Refresh Data Source
Select new column from the Data Source to add it to your app
Change Patch function to include the new column "lat_long1"
Now Patch function works
@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.

Was this reply helpful? Yes No
tianaranjo 497 on at

Like (0)

Report
Copy link

Link copied!

@ericonline

Thanks for all the follow-up and screen shots! And, happy the work around worked 🙂
I hope this is a bug that gets ironed out in the future. It is the first time I have come across this issue.

@v-xida-msft - Thank you for the time you took to reply!

Was this reply helpful? Yes No
tianaranjo 497 on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft
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?

Was this reply helpful? Yes No