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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
elbent 87 on at

Like (1)

Report

Thanks, this got me what I needed!

Was this reply helpful? Yes No