cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FioriniC
Level: Powered On

Problem with Update on SQL SERVER table

Hi everyone.

Today is my third days on powerapps. Sorry for the question but i don't find nothing can help me.

I be able to insert new record on a sql server table, but when i tried to update make an errors

I tried with Update and UpdateIf command but no way.

The table has a Id incremental and primary key

 

this is a sintax of UpdateIf 

UpdateIf('[dbo].[CheckInOut]';ID=GA_Clienti.Selected.idCheck;{DataCheckIn = Text(MDataCheckIn)})

 

and this of Update

Update('[dbo].[CheckInOut]';First(Filter('[dbo].[CheckInOut]';GA_Clienti.Selected.idCheck = ID) );{ DataCheckIn:Text(MDataCheckIn)})

 

I've read the Microsoft manual but i dont' find nothing. I don't understand the reason o this problem

Thanks in advance for your help and patience