Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Unable to patch record

I am unable to patch records to a table.  Powerapps says the table is read only, however it is not. The source is SQL.

Super User III
Super User III


Two questions:


  • Did you define a primary key?  If not, PowerApps will give this warning
  • Are you using a SQL view?  If yes, PowerApps will give this warning.


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Dual Super User III
Dual Super User III

are you talking about a SQL Table via a SQL connector or a Power Apps data table populated from a SQL connection?  If its a SQL table then @mdevaney is correct.  To write from Power Apps to SQL you need a SQL Identity column as the primary key in the table or the table is treated as read only.


If you mean a Data Table then it doesn't matter because Data Tables in Power Apps are Read Only copies of data and can't be written to.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,485)