cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hsyn_tknlp
Regular Visitor

EditForm DataCard Edit/Update issue

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:

hsyn_tknlp_0-1668858507064.png

The PowerApp DataCard:

hsyn_tknlp_1-1668858734335.png

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@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... 

View solution in original post

2 REPLIES 2
DavidZoon
Responsive Resident
Responsive Resident

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 ?

DavidZoon_0-1668867136262.png

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
Super User
Super User

@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... 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,434)