EditForm DataCard Edit/Update issue

[hsyn_tknlp]

Hi,

our app was created based on SQL tables,

there is an edit form connected to the specific table and we have added a new column (Role_Person_Key) (INT) into the respective table,

The table structure:

The PowerApp DataCard:

the issue is : the edit form is not able to edit the new column/field, could not figure out the reason, there is no UPDATE control and having label instead of text input,

anyone faced with the similar issue or having any idea ? 

applied below points but no chance so far : 
-> The DataCard was removed and added it back, - no success

-> The column was deleted on DB and added back to the table, - no success

-> Created a new form and added the DataCard again, - no success

Thanks!

[DavidZoon]

Hello,

If you have no 'Update' parameter in your datacard, means your field is 'read only' for some reason.

Can you see all these option when you change Control Type of your datacard ?

If yes, select "Edit Number", your datacard will have an update parameter again

If no, Your Column is Read only at DB level or your form is a ViewForm, not an EditForm

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

[Drrickryp · Accepted solution]

@hsyn_tknlp 

I believe it may have something to do with the "int null".  I saw something about Null values and an experimental feature several years back that applies to Sql.  See if this helps https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-dat...