cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex777
New Member

SQL connection read-only

Hey guys!

 

I'm trying to make my first steps with powerapps.

Now i got following issue: I want to update a record on MS SQL Server using "Patch". This ist my statement: 

 

 

Patch(Abholauftraege; First(Filter(Abholauftraege; ID = ThisItem.ID)); {AbgeholtUser:User().FullName})

 

 

 

There is this message: "The datacource is read-only or without primary key so that the function "Patch" can not read data" (Translated from german)

 

The table has a primary key and the user i'm using for the dataconnection has all rights, including admin.

 

Do you have any ideas, what i', doing wrong?

 

greets

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

Are you updating a Table or a View in SQL?  Is ID the primary key in the SQL table?



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

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Hi!

 

I'm updating a table and ID ist the primary key.

Is the ID column also marked as the Identity column?



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

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,057)