cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
New Member

Re: Cant create a card that has the update property on it

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
Highlighted
Power Apps
Power Apps

Re: Cant create a card that has the update property on it

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

Highlighted
Frequent Visitor

Re: Cant create a card that has the update property on it

Capture.PNG

 

 

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

 

Highlighted
New Member

Re: Cant create a card that has the update property on it

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

Highlighted
Super User
Super User

Re: Cant create a card that has the update property on it

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
Highlighted
New Member

Re: Cant create a card that has the update property on it

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.

 

 

Highlighted
New Member

Re: Cant create a card that has the update property on it

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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,206)