cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juandavidlozano
Frequent Visitor

Cant create a card that has the update property on it

So when I create an Edit form and connect to my data source it creates the cards for the fields automatically but It those cards dont have an update property, I read this 

 

The stock custom card is missing the Update property, which is required to write back changes. To work around this:

  • Select the form control, and insert a card by using the right-hand pane based on the field that you want the card to show.
  • Unlock the card, as described in Understanding data cards.
  • Remove or rearrange controls within the card as you see fit, just as you would with the custom card.

Can somebody tell me how to create a card that is not a custom card? Anything I create does not have the update property on it.

 

1 ACCEPTED SOLUTION

Accepted Solutions

I had the same issue 

 

I figured out that the problem was with the column datatype in SQL Server. 

I was using UNIQUEIDENTIFIER, and after I changed it to NVARCHAR(MAX) I got the update filed back.

 

@Rafal1 I guess that you are using the BIT datatype.

 

With datatype: UNIQUEIDENTIFIER see before.png

 

With datatype NVARCHAR(MAX) see after.png

 

View solution in original post

6 REPLIES 6
AKotb
Power Apps
Power Apps

Unlocking the card should convert it to a custom card with the update property, you can see the update property by expanding the data properties section in the advanced panel (by clicking on the more options button)

 

image.png

Capture.PNG

 

 

Still no luck, I am attaching a picture that shows probably the same you are showing me but still no update field

 

Hey, Juan , is this still the issue for you ? I have the same and I can't fight it now.

With a SQL datasource you have to have a primary key for your table or PowerApps cannot created, edit, or delete. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Rafal1
New Member

I came across the same problem and I can say that the addition of primary keys to the data source tables did fix my problem, however, I had to create my app from scratch for those changes to have a positive effect on my app. Simply refreshing the data sources in an already existing app had no effect whatsoever.

 

 

I had the same issue 

 

I figured out that the problem was with the column datatype in SQL Server. 

I was using UNIQUEIDENTIFIER, and after I changed it to NVARCHAR(MAX) I got the update filed back.

 

@Rafal1 I guess that you are using the BIT datatype.

 

With datatype: UNIQUEIDENTIFIER see before.png

 

With datatype NVARCHAR(MAX) see after.png

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (57,438)