Run time error in power apps

[rmaziwis]

Hi All 

I have a form in power apps that I capture Vehicle incident information .But when I try to save this form Iam getting a run time error that some columns are invalid but these columns are available in my  SQL table and at the bottom the message includes these columns as valid which does not make sense .Please see my attachments any ideas to resolve this will be welcome whilst I try something else quickly .

[v-xida-msft]

Hi @rmaziwis ,

Based on the error message that you mentioned, it seems to tell that there is something wrong with the SQL Table connection within your app.

Please consider re-create a new connection to your SQL Table from your app, then bind the new added SQL Table data source to the Edit form, then try it again, check if the issue is fixed.

Also please make sure that you haved defined a proper PRIMARY KEY within your SQL Table.

Best regards,

[rmaziwis · Accepted solution]

In my sql table on the columns that were failing to save I had spaces .Dropped the table recreated a new table with no spaces and it worked.