Answered

Patch error 8 constraint violation when patching Sharepoint item

(0) Share

Report

Posted on by elbent

I am trying to patch a sharepoint list item but it is showing that the request is invalid, and I can't figure out why.

Patch('VFRS App Vehicles', 
 LookUp('VFRS App Vehicles', 
 VIN = Reservation.VIN), 
 { Mileage: NewMileage});

VIN is a single line of text, Mileage is a number (might need to add .Value since NewMileage is a text box, but that doesn't fix my issue). I'm seeing that error 8 is a constraint violation, but I don't know why I would need to update any other fields if I just want to change one.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @elbent

Are you trying to update a certain item/row in the database.

Yes Patch can also be used but most of the time I get an error with Patch so I prefer UpdateIf over Patch.

You can try something like below:

UpdateIf(
'VFRS App Vehicles',
VIN = Reservation.VIN,
{ Mileage: Value(NewMileage.Text) }
)

I hope this helps 🙂
elbent 87 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks, this got me what I needed!