Announcements
I am unable to patch records to a table. Powerapps says the table is read only, however it is not. The source is SQL.
@drobinson
Two questions:
---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."
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 377 Most Valuable Professional
11manish 165 Super User 2026 Season 2
MS.Ragavendar 110 Super User 2026 Season 2
