cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

SQL Server getting error: "The specified column is generated by the server and cant be specified"

I am trying to insert new data into my database with the powerapps. I have an AWS SQL db and I'm trying to do this via forms...

Here is a print of my app form: 

Sem título.png

But when I click on "Enviar Relatório", that is "Submit Report" on PT-BR, I get this error:
"data: The specified column is generated by the server and cant be specified"

My database Structure is this one:

Sem título.pngMy DB

 

Why am I getting this error and how can I fix it?

1 ACCEPTED SOLUTION

Accepted Solutions
bkeano Advocate I
Advocate I

Re: SQL Server getting error: "The specified column is generated by the server and cant be specified"

HI

Know this is 4 weeks old now, so assume you have solved, but looking at your SQL table, you don't have a primary key on your table, so without this you cannot create a new record in your table from PowerApps

View solution in original post

1 REPLY 1
bkeano Advocate I
Advocate I

Re: SQL Server getting error: "The specified column is generated by the server and cant be specified"

HI

Know this is 4 weeks old now, so assume you have solved, but looking at your SQL table, you don't have a primary key on your table, so without this you cannot create a new record in your table from PowerApps

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,258)