SubmitForm updating records but won't create new one

(0) Share

Report

Posted on by MP-13011217-0

158

Hello All,

I have an issue with my app as there is gallery connecting to dataverse table and a form for editing existing records and creating new one. When I select my record in gallery it populated all details in form and I can change it then press button "Save" and I can see my changes straight away. When I press another button "Add new" my form is blank and when I fill it and press the same button "Save" it gives me error: "The specified column is generated by the server and can't be specified."

Button "Save" code: SubmitForm(Form3)

Help please!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@marcy_pi

One or more of the columns in your Dataverse table is set to Autonumber. Take this one off your form.

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Where is this setting "Autonumber", please? I have two columns with "choice" and 6 columns with Text with various formats like phone number or email. i don't have any column with number there.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@marcy_pi

To troubleshoot your issue, and assuming your gallery is Gallery1.

put a form on the screen and using the right hand side of the screen, select your your table as the datasource. The form should populate with your fields. Assume it is named Form1.

Leave the Item property blank for now.

Set the Default mode property to New

Put a button on the screen and set it's OnSelect to SubmitForm(Form1)

Put Notify("It Worked!", Success) in the OnSuccess property of Form1

Enter some data, push the button and see if it works.

Was this reply helpful? Yes No
MP-13011217-0 158 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for Your reply, no it is showing the same error.

Was this reply helpful? Yes No