Announcements
Is it possible to edit a Table/or View from sql server that does not have a primary key ?
Thanks
David
Hi David,
No, it's not possible to edit a record from a SQL Server table that doesn't contain a primary key.
Without a primary key, PowerApps isn't able to uniquely identify the record to update.
@Anonymous
If your SQL table does not have a primary key the app will only be able to read-in data but not edit.
Check out this 4 min video on Youtube to hear the complete explanation why. Note: this is not my video but I liked the discussion.
https://www.youtube.com/watch?v=hsH1hobr1cg
---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."
at(everyone),
Can you edit a sql server view ? and if so ?
...So if even a view, is based upon several select statements, EVERY select table must have a primary key also ?
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 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
